Hi,
i am trying to do concat in transformer getting error
to_transf.NFNAME || ':'|| to_transf.LNAME
Thanks
Concatenation
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
If you want ':' between Firstname and LastName then use in column derivation
Code: Select all
FirstName:':':LastName
hi sam here
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Beware null values. Null concatenated to anything will result in null. You must handle this. For example:
Code: Select all
NullToValue(InLink.LastName,"?") : ", " : NullToEmpty(InLink.FirstName)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.