Null Handling Functions
Posted: Tue Mar 18, 2008 1:37 am
Hi friends,
My Input Source
Id,Name,Age
A1307420,Arun,25
A1307421,Venkat,26
A1307422, ,27
In the third row Second column I have a Space which is a null value, I need an Output as follows Using Transformer stage especially using Null handling functions like Isnull, Isnotnull, Nulltovalue, etc.
Id,Name,Age
A1307420,Arun,25
A1307421,Venkat,26
A1307422,Vignesh,27
Thanks in advance..
Regards
Rajasingam. :D
My Input Source
Id,Name,Age
A1307420,Arun,25
A1307421,Venkat,26
A1307422, ,27
In the third row Second column I have a Space which is a null value, I need an Output as follows Using Transformer stage especially using Null handling functions like Isnull, Isnotnull, Nulltovalue, etc.
Id,Name,Age
A1307420,Arun,25
A1307421,Venkat,26
A1307422,Vignesh,27
Thanks in advance..
Regards
Rajasingam. :D