topic Re: Check null for a column having integer datatype and Replace with some number or "undefined" in Talend Studio

Check null for a column having integer datatype and Replace with some number or "undefined"

sbxr — Wed, 26 Sep 2018 14:11:17 GMT

Hi Team,

I have columns in my data which has some null values and want to replace it with some integer value such as 0. and other null values with undefined.

like for string we do it like :

row1.test==null ||

row1.test==null?"undefined" :row1.test1

Want it for int

Regards

Re: Check null for a column having integer datatype and Replace with some number or "undefined"

TRF — Wed, 26 Sep 2018 14:47:05 GMT

row1.test == null ? "Undefined" : Integer.toString(row1.test)

Re: Check null for a column having integer datatype and Replace with some number or "undefined"

fdenis — Thu, 27 Sep 2018 09:33:03 GMT

if you want to have Integer and Strings (undefined) on the same column… all your data will be String
"0"
"1"
"undefined"
…

if your input column can be null it's an Integer (object (not an int)) so you have to convert it to String.

(row1.test==null)?"undefined" :row1.test.toString()

Re: Check null for a column having integer datatype and Replace with some number or "undefined"

TRF — Thu, 27 Sep 2018 09:41:44 GMT

Did this help?

If so, thank's to mark your case as solved (Kudos also accepted).

Re: Check null for a column having integer datatype and Replace with some number or "undefined"

sbxr — Thu, 27 Sep 2018 11:56:11 GMT

Yes it is working as I wanted ..

Thank you very much..

Re: Check null for a column having integer datatype and Replace with some number or "undefined"

TRF — Thu, 27 Sep 2018 12:19:45 GMT

@sbxr, so you could validate the 1rst answer, not the 2nd one which is just a copy of the previous one.

When you help someone, do you like that the thanks go to someone else than you?

I don't!

Re: Check null for a column having integer datatype and Replace with some number or "undefined"

sbxr — Thu, 27 Sep 2018 12:36:51 GMT

Yes you are right @TRF ..

my thank you is for every one in general..

Pardon me and respect

@sbxr