concatenating string

[kjaouhari]

Hi all ,

I want in a transformer to do :
column1:' ':column2 ---> target
55 :' ': KK ---->55 KK
And when column1 is empty I'm expecting to have
column2 -->target

but I have nothing in target

Do you have an idea ?

[ArndW]

Are you doing a simple derivation in a transform stage? If your first column is empty, what output are you getting that is wrong?

[JeroenDmt]

If one of the two columns is NULL, the result will be NULL and not what you're expecting.
You'll have to catch the NULL and convert it to an empty string

[garthmac]

I use the transform srNVL on each input column to set NULLS to empty strings before concatinating.

[kjaouhari]

Thanks all,

I use the DS transform to set NULLS to empty strings in my concatinating.

It's works good!