Four Stars

How to replace a "NULL" to an empty string

Hi All,
I have an use case where we have data in sql server which stores the keyword NULL but my target which is Snowflakes doesn't accept NULL. Is there a component that I can use to convert the NULL to like an empty string. Any help is appreciated.
3 REPLIES
Moderator

Re: How to replace a "NULL" to an empty string

Hi,
You can use tMap or treplace component to achieve your goal.
In tMap, the expression should be:row1.input==NULL?"":row1.input
Let us know if it is Ok with you.
Best regards
Sabrina
 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: How to replace a "NULL" to an empty string

Hi,
Yes that worked for me. Thanks
Moderator

Re: How to replace a "NULL" to an empty string

Hi,
Can we consider this topic as resolved? Feel free to let us know if there is any further help we can give.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.