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
Null Handling Functions
Moderators: chulett, rschirm, roy
There is a space and not a null as ArndW mentioned, so cannot use functions such as isnull() here. based on your statement which says there is "a" space. you can check for that and code that in the if then else
Code: Select all
IF input.field ='' then This else That