topic How to replace a "NULL" to an empty string in Talend Studio

How to replace a "NULL" to an empty string

Anonymous — Fri, 17 Feb 2017 20:45:46 GMT

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.

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

Anonymous — Mon, 20 Feb 2017 08:19:53 GMT

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

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

Anonymous — Tue, 21 Feb 2017 19:43:04 GMT

Hi,
Yes that worked for me. Thanks

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

Anonymous — Wed, 22 Feb 2017 08:49:35 GMT

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

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

Anonymous — Fri, 28 Dec 2018 09:07:03 GMT

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.