topic Filtering in tmap in Talend Studio

Filtering in tmap

xx_emanis — Fri, 22 Feb 2019 17:36:33 GMT

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

Re: Filtering in tmap

TRF — Fri, 22 Feb 2019 18:02:48 GMT

"&&" 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")

Re: Filtering in tmap

xx_emanis — Fri, 22 Feb 2019 19:16:15 GMT

Thank You. That worked.