Filter rows based on more the two condition.

[sbxr]

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               

source-id	Name
4	test
1	hello
2	first
2	first
3	three
1	hello
4	test
2	first

Out1(1,2,4)                                                

source-id	Name
1	hello
2	first
2	first
1	hello
4	test
2	first

Out_2(3)

source-id	Name
3	three

Regards

[TRF]

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

[sbxr]

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

[manodwhb · Accepted solution]

@sbxr ,check the below way.

[TRF]

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.