Enterprise Guide Concatenate Columns - output different order

[maliksmom2000]

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)

[Astounding]

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.......)

[ballardw]

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.