Hi,
I am trying to use the Modify Stage to handle Null for one of the column by replacing with value from another input column. Is it possible ?
Specification that I have tried but didn't work looks similar to the one below.
Ex. COL2 = handle_null (COL2,COL1)
Thanks
Arvind
Modify Stage handling NULL replacing with another column
Moderators: chulett, rschirm, roy
Modify Stage handling NULL replacing with another column
Thanks & Regards
arvind sampath
Software Engineer
arvind sampath
Software Engineer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm pretty sure that the second argument to handle_null() must be a constant.
As a more general rule Modify stage functions can only operate on one input field.
As a more general rule Modify stage functions can only operate on one input field.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: