topic Using tmap to implement "not in" condition in Talend Studio

Using tmap to implement "not in" condition

Aami — Sat, 16 Nov 2024 04:05:19 GMT

I have a job where it extracts all the IDs from an API and these IDs are passed into another API to get further details. Now the requirement was to ignore some of the IDs from the above and the list was supposed to be dynamic.

Basically I needed something similar to "Not IN" condition of Sql.

Solution: I stored the Ids in context value in format ID1 | ID2 | ID3 |ID4 and added below condition in tMap which essentially does the job.

!((String)globalMap.get("id")).matches(context.EXCLUDED_ID)

Re: Using tmap to implement "not in" condition

Ganshyam — Tue, 19 Nov 2019 11:03:09 GMT

Hello,

Instead of matches make use of equals.

!((String)globalMap.get("id")).equals(context.EXCLUDED_ID)

Thanks

Re: Using tmap to implement "not in" condition

Aami — Wed, 20 Nov 2019 06:31:42 GMT

Hi,

My excluded ID has a variable number of IDs and equals function can compare with only one ID. And this is the reason I'm using matches. It can compare any number of IDs stored as ID1|ID2|ID3|ID4|... in context.