create a null column in Modify stage
Moderators: chulett, rschirm, roy
create a null column in Modify stage
Hi every body,
I want to know if it is possible to create a null column in Modify stage.
tanks for help
Best Regards,
Mustapha
I want to know if it is possible to create a null column in Modify stage.
tanks for help
Best Regards,
Mustapha
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 27
- Joined: Mon Aug 15, 2011 7:32 am
- Location: Chennai
- Contact:
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
you can create a nullable column in modify stage but you cant set it to null for all records
col1=make_null(col2,1)
would set the column col1 to NULL if col2 happes to be contain 1 else col1 would take col2 value.
col1=handle_null(col2,1)
the above would set col1 to '1' if col2 happens to be NULL else col1 will take col2 value
In either case you cant have col1 generated in the modify stage and set it to NULL for all records unless you already have a column which has same value for all recods and then use make_null function
col1=make_null(col2,1)
would set the column col1 to NULL if col2 happes to be contain 1 else col1 would take col2 value.
col1=handle_null(col2,1)
the above would set col1 to '1' if col2 happens to be NULL else col1 will take col2 value
In either case you cant have col1 generated in the modify stage and set it to NULL for all records unless you already have a column which has same value for all recods and then use make_null function
- Zulfi
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
you dont have to use transformer, a column generator with Nulls percentage=100 would suffice if you wish to generate a new column and fill all NULLS in it.mustapha wrote:After testing and research, I think that impossible to create a null column using Modify stage, you must necessary use the Transformer stage. the function make_null() and hundler_null() don't work in this case.
- Zulfi