topic Re: Filter rows based on more the two condition. in Talend Studio

Filter rows based on more the two condition.

sbxr — Sat, 16 Nov 2024 04:43:49 GMT

Hi,

i have a table where source id is one column having multiple sources like below, i want to have multiple outputs based on different ids

i want to create two flow where one output table/file will contain all the data with source-id(1,2,4) and other output table/file will have (3)

Input

Out1(1,2,4)

Out_2(3)

source-id	Name
3	three

Regards

TRF — Wed, 11 Sep 2019 06:06:36 GMT

Use tFilterRow (or tMap with according expression on output filter if you have something to transform)

sbxr — Wed, 11 Sep 2019 12:38:55 GMT

Yes thank you , but how to implement above in tmap filter
what and how the condition i need to write.

manodwhb — Wed, 11 Sep 2019 12:47:13 GMT

@sbxr ,check the below way.

TRF — Wed, 11 Sep 2019 12:52:42 GMT

Here is an example:

Define 2 output flows into the tMap.

For the 1rst one, define an expression filter as "row5.sourceId != 3" (for example).

For the 2nd one, just set the Catch output reject option to true.