Hi
I have requirement like
i am getting the source like this and i need concatenate all the four columns in to one target column
Country Account Region Geo
--------- ------- -------- ------
226 152 (Null) 238
The target should be like this
226|152||238
But i am getting only if any null value comes then this not working.
i did null handling like IsNull(col) then '' Else col.
even thout i am getting like "226|152". i am not getting after null values
help me in this regard
Thanks
Prams
concatenation problem
Moderators: chulett, rschirm, roy