Concatenation

times29 · Post by **times29** » Mon Apr 11, 2011 2:19 pm

Hi,
i am trying to do concat in transformer getting error
to_transf.NFNAME || ':'|| to_transf.LNAME

Thanks

chulett · Post by **chulett** » Mon Apr 11, 2011 2:26 pm

DataStage uses a semi-colon for concatenation, let the Expression Builder put it together for you if you are unsure.

samsuf2002 · Post by **samsuf2002** » Mon Apr 11, 2011 2:32 pm

to_transf.NFNAME : to_transf.LNAME

Should be good.

times29 · Post by **times29** » Mon Apr 11, 2011 2:53 pm

problem is want sumthing like Firstname:lastname can we do that in transformer

Nagaraj · Post by **Nagaraj** » Mon Apr 11, 2011 2:58 pm

pretty straight forward expression...dsgurus have already mentioned it. please try it and let us know if you are getting the desired results.

samsuf2002 · Post by **samsuf2002** » Mon Apr 11, 2011 3:01 pm

If you want ':' between Firstname and LastName then use in column derivation

FirstName:':':LastName

ray.wurlod · Post by **ray.wurlod** » Mon Apr 11, 2011 4:45 pm

Beware null values. Null concatenated to anything will result in null. You must handle this. For example:

NullToValue(InLink.LastName,"?") : ", " : NullToEmpty(InLink.FirstName)