Desktop productivity for business analysts and programmers

Enterprise Guide Concatenate Columns - output different order

Reply
New Contributor
Posts: 2

Enterprise Guide Concatenate Columns - output different order

Thank you for the help, I am a little frustrated.  I used the CATX function in EG and the expression is valid.  The output did concatenate the requested columns, trim the front and back spaces and also put in a separator.  However, the output is in a different order than the expression.  What am I doing incorrectly?

 

CATX(t1.DA_NBR, t1.DA_FRAC_NBR, t1.SA_SN_PRE_DRCT_CD, t1.SN_TXT, t1.SA_SN_ST_TY_CD, t1.SA_SN_POST_DRCT_CD, t1.DEST_TY_CD, t1.DEST_TXT, t1.CITY_NM, t1.ST_ABBR_NM, t1.DPA_BSC_ZIP_CD)

 

 

Super User
Posts: 6,919

Re: Enterprise Guide Concatenate Columns - output different order

Posted in reply to maliksmom2000

What did you expect as a separator? 

 

In CATX, the first parameter is the separator.  So this is requesting that the value of t1.DA_NBR be used as the separator.  That might be your intention, but it seems unlikely.  Perhaps you need to insert:

 

CATX(' ', t1.DA_NBR.......)

Super User
Posts: 13,906

Re: Enterprise Guide Concatenate Columns - output different order

Posted in reply to maliksmom2000

When code goes wrong it often helps to show 1) the actual result from the code and 2) the expected result when you have one.

 

If the result is as @Astounding suggests it would likely show up pretty easily especially when compared to an expected value. In fact it would likely show if only 3 or 4 variables were concatenated.

Ask a Question
Discussion stats
  • 2 replies
  • 245 views
  • 2 likes
  • 3 in conversation