How to replace a "NULL" to an empty string

[Anonymous]

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.

[Anonymous]

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
 

[Anonymous]

Hi,
Yes that worked for me. Thanks

[Anonymous]

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

[Anonymous]

Hi Sabrina,

I am facing similar issue using Snowflake as the Database. row1.input==null? "": row1.input is throwing error as NULL cannot be inserted into Database.

Could you please suggest a solution for this.

Regards,

Saravanan.