Use Modify stage for converting null string to empty string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
Use Modify stage for converting null string to empty string
What is the syntax to be used within the Specification of Modify Stage if I need to convert a null value into empty string. In short I need the equivalent of NullToEmpty(Fieldname) which we usually use in transformer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The function is handle_null().
Code: Select all
outcolumn=handle_null(incolumn,"value")
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.
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am