Hi All,
Please let me know if I am trying to concatenate two columns from source and loading into target as single column. On source side, one column having value other one is maybe null. Usually if we add string with null we get null.
How can we overcome this problem?
we are using 7.1 server
Thanks & Regards
Deva
Problem with Concatenate the string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Mon Jul 24, 2006 9:27 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please post server questions in the server forum.
Use the NullToEmpty Transform
Use the NullToEmpty Transform
Code: Select all
NullToEmpty(FirstString):NullToEmpty(SecondString)
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.