Kumar,
Did u try handling it with the IF ISNULL(LINKNAME) logic?
I had this problem as well, you might want to check the logic for the condition too which is defaulted to Reject. ( this will be in a lookup stage).
How to avoid NULL to reject - in SWITCH case
Moderators: chulett, rschirm, roy
This post was started for discussing the condition check for Null in switch stage. Where we cant use IF ISNULL(LINKNAME) logic in that. Later this post has been hijacked to experiment, how to hold a NULL value in Decimal/dfloat, apparently some of us are getting 0s instead of NULL in the nullable field.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Re: How to avoid NULL to reject - in SWITCH case
Kumar,kumar_s wrote:Hi all,
In input stage i have a column STATUS which cant have Y or N or null. I used switch to seperate to two pipeline. null should go to N link. Bul i can handle null value to flow to a stream, it goes to Reject link. I tried with '' , "", @NUL, @NULL.STR , NULL but doesent work. But i can make it up with transformer stage with "".
STATUS is Varchar with 1 byte length. Can any one help me out.
Thanx in advance
-kumar
Your source datatype is Varchar. So if the input value is empty, it is assuming it to be a empty string i.e. "" and not as null. So i think should be checking for STATUS='' instead of "STATUS is null" or something else.
Hope this helps, even if the reply is too late...
Warm regards
Senthil
Re: How to avoid NULL to reject - in SWITCH case
Hi Senthil,ThilSe wrote:Kumar,kumar_s wrote:Hi all,
In input stage i have a column STATUS which cant have Y or N or null. I used switch to seperate to two pipeline. null should go to N link. Bul i can handle null value to flow to a stream, it goes to Reject link. I tried with '' , "", @NUL, @NULL.STR , NULL but doesent work. But i can make it up with transformer stage with "".
STATUS is Varchar with 1 byte length. Can any one help me out.
Thanx in advance
-kumar
Your source datatype is Varchar. So if the input value is empty, it is assuming it to be a empty string i.e. "" and not as null. So i think should be checking for STATUS='' instead of "STATUS is null" or something else.
Hope this helps, even if the reply is too late...
Warm regards
Senthil
Thanks for your comments.
Code: Select all
I tried with '' , "", @NUL, @NULL.STR , NULL but doesent work.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'