topic Re: Filter rows for a column with multiple values in Talend Studio

Filter rows for a column with multiple values

krrohit1256 — Sat, 16 Nov 2024 03:20:53 GMT

I have a column named subject.

I want to filter out records only with subjects as Maths or English.

i want to implement this in tmap.

i can use the filter expression

row1.subject.equas("Maths") || row1.subject.equals("English")

But is there some other way because i have multiple values and not just 2 . Some thing similar to 'IN' operator

Re: Filter rows for a column with multiple values

TRF — Thu, 06 Feb 2020 07:51:59 GMT

You can put these values into a file, then read it with a tFileInputDelimited connected to a tMap as a lookup.

In the tMap, connect row1.subject to the lookup field to define the join between the main and the lookup rows (very basic and standard pattern). If subject are static, you can replace tFileInputDelimited by tFixedFlowInput.