Comparing String less than values

[Prasanna3]

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

[billimmer]

Use tFilterRows and check the value there

[manodwhb]

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

[Prasanna3]

String data types.

[manodwhb · Accepted solution]

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"

[Prasanna3]

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

[manodwhb]

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