topic tmap catch nulls in Talend Studio

tmap catch nulls

Anonymous — Sat, 16 Nov 2024 07:14:51 GMT

Hello

I am trying build a job where a list of attributes are loaded from a csv file and for each loaded row a tMap component catch the nulls and change it for a different value. row3 to output1

I am only able to do it in String, can you help me finding the function for:

- Integer

- Floats

-Doubles

Re: tmap catch nulls

vapukov — Wed, 21 Nov 2018 01:58:21 GMT

generally, the same construction must work for all 3 types (Integer, double, float)

Integer is possible to compare with null, Int not

Re: tmap catch nulls

Anonymous — Wed, 21 Nov 2018 02:32:13 GMT

i was only able to create the function to strings which doesn´t work for any kind of those

Re: tmap catch nulls

Anonymous — Wed, 21 Nov 2018 04:57:42 GMT

Generally, if you input a csv file, which the row is in integer or double or long type. The NULL value often default is 0 in row so the easiest way just compare if it's > 0.

Screenshot from 2018-11-21 11-56-04.png