can switch stage filter the null values?

vasam · Post by **vasam** » Wed Apr 28, 2010 1:39 am

Hi All,

I have a requirement which is i am getting some status like COMT,PEND,FAIL,NULL from my source file. what i need to do is i have to filter the status and send it to each file.

so i had used one switch stage to filter the status, but NULL status is not recognizing in SWITCH stage?

If any NULL comes i have to send this entire record into one file.

how can i do this?

suggest me.

Thanks,
Vijay

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 1:53 am

Is this null or the word "NULL"?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 1:55 am

Moderator: please move to Enterprise Edition (parallel) forum

vasam · Post by **vasam** » Wed Apr 28, 2010 2:06 am

Thanks for your reply ray..

I have tried both NULL AND is null but its not recognizing.

when i put the condition (other) in swith stage all NULL status records are going to OTHER file.

vasam · Post by **vasam** » Wed Apr 28, 2010 2:07 am

it is word 'NULL '

vasam · Post by **vasam** » Wed Apr 28, 2010 2:58 am

Hi,

Can any body reply to above question?

thanks

udayk_2007 · Post by **udayk_2007** » Wed Apr 28, 2010 3:07 am

I tried using word NULL in switch stage and it is working fine. With null, it doesn't work.

ETLJOB · Post by **ETLJOB** » Wed Apr 28, 2010 3:22 am

vasam wrote:it is word 'NULL '

It seems the word 'NULL' is working fine in Switch.

I could see a space after the word 'NULL', in your post. I hope, its a typo error. If it is not the case then remove that space in your job and give a try.