01-30-2018 04:55 PM
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)
01-30-2018 05:12 PM
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.......)
01-30-2018 06:41 PM
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.