topic Re: Comparing String less than values in Talend Studio

Comparing String less than values

Prasanna3 — Fri, 27 Mar 2020 16:28:56 GMT

Hi Team,

I am receving data from the feed like below.
Amount,empno
0.0,100
-1,300
I have to check if the amount <0.0 then we should mark that record as Failed.
can some one suggest me solution.

Thanks,
Kumar

Re: Comparing String less than values

billimmer — Fri, 27 Mar 2020 17:31:24 GMT

Use tFilterRows and check the value there

Re: Comparing String less than values

manodwhb — Mon, 30 Mar 2020 05:41:25 GMT

Use to tmap to write expressions like. What is the data type of amount.?

Re: Comparing String less than values

Prasanna3 — Mon, 30 Mar 2020 06:02:05 GMT

String data types.

Re: Comparing String less than values

manodwhb — Mon, 30 Mar 2020 06:12:45 GMT

OK then use expression like below in the output field. And the output data type should be strong.
Integer.parseInt(row1.amount)<0?"failed":"pass"

Re: Comparing String less than values

Prasanna3 — Mon, 30 Mar 2020 06:18:23 GMT

I am getting values from the feed like 0.0 and -1.0 like that .will your solution work for that also?

Re: Comparing String less than values

manodwhb — Mon, 30 Mar 2020 06:19:55 GMT

if your source data type is string then sure that solution works.