Dear All,
I would like to see if it is possible to create a null column in Modify stage. Also, in the specification box, when I try to enter "USERID = SetNull" the compiler treated "SetNull" as a input dataset field instead of treating as a build-in function. Can anyone provide the syntax of using SetNull Function in the Specification box?? Thank you so much!!
Best Regards,
royhhlai
create column with null value in modify stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You cannot create something out of nothing in a Modify stage. It cannot add columns, it can only copy columns or convert columns. Your specification needs to include an existing column name. If you want to generate a new column use the column generator stage or the transformer stage.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 15
- Joined: Wed May 26, 2004 6:30 am