Filtering in tmap

[xx_emanis]

Hello All,

Im trying to filter two columns ORGANIZATION_ID and TRANSACTION_SOURCE_TYPE_ID in my job and below is the expression I used in TMAP. 

Not sure why but the job is not loading any records to the target table. Please correct me if im missing anything in the way I used the expression in TMAP.

Thank You

[TRF · Accepted solution]

"&&" is for "and". For "or" use "||" as ORGANIZATION_ID cannot be equals to 116, 117, ... at the same time!

The answer is

(Source1.ORGANIZATION_ID.equals("116") || Source1.ORGANIZATION_ID.equals("117") || ...) && 
Source1.TRANSACTION_SOURCE_TYPE_ID.equals("25")

[xx_emanis]

Thank You. That worked.