CODEWITHSUNDEEP
if-statementconditional-statementstalend
imssurya
imssurya

Reputation: 577

How to check column values in talend tmap?

In talend DI, tmap component, I need to pass value to target file from source when a another column value is not between 53 and 100 and another column value is not equal to "POOL".
I need to check these conditions. Can anyone help to solve this problem ?

Upvotes: 0

Views: 4209

Answers (2)

Horse_1995
Horse_1995

Reputation: 247

You can try like this....

arrange tmap settings as,

enter image description here

the condition in expression filter is

!(row1.newColumn >53 && row1.newColumn<100)&& (!row1.newColumn1 .equals("POOL"))

then u can get required result..

here i take the following as input..

20;A

30;POOL

40;C

50;D

60;POOL

100;G

110;POOL

then i got result as,

enter image description here

Upvotes: 0

PreetyK
PreetyK

Reputation: 451

In Filter section of target schema in tMap component, write

(row1.column2 > 53 && row1.column2 < 100) && (!row1.column3.equals("POOL"))

and assign row1.column1 to target schema column.

Hope this helps...

Upvotes: 0

Related Questions