DSXchange

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

use function NullToEmpty(Region ) to get expect output

use function 'NullToEmpty(Region)' to get expect output[/code]

is that column under consideration is defined as Nullable yes in datastage?