topic Re: tMap - tfilterrow and float values in Talend Studio

tMap - tfilterrow and float values

Anonymous — Mon, 17 Dec 2018 23:05:17 GMT

Hi,

I'm looking for some help about an issue I can't solve. Here's the case :

I have a delimited file that looks like this :

Column1,Column2,Column3

Toto, Tata, 59.8

Tito, Tutu, 12.9

I want to filter the two last rows (I just want to use the not empty lines).

Things I've tried so far :

- use of a tMap to populate the empty rows and then filter those rows. The column3 is of float type and when I try to check row1.Column3 == 0.0f I get a NullpointerException

- use of a tfilterrow to use only rows that match some condition -> same issue with the float column

- use of the Skip Empty Rows option of tFileInputDelimited but with no success

Can you please help me ?

Thanks in advance

Re: tMap - tfilterrow and float values

vapukov — Tue, 18 Dec 2018 00:06:34 GMT

solution 1

define this col3 as type string and before tMap use tFilterRow (not equal to "") then convert to float

solution 2

in input component deine col3 as NOT NULL and assign default value somewhere outside your range (negative or 0 or huge)

it just for start

Re: tMap - tfilterrow and float values

Anonymous — Tue, 18 Dec 2018 11:58:42 GMT

Thank you very much !! Works perfectly