Split output file

[NAndrew1652694287]

Hey there guys,

I'm a newbie here in Talend and what I am trying to do is to split different output file, here is an example of the file that I am working on...

For example:

Whenever I see a column with a true value I need to produce different file of it including the row with the value of true.

So the output should be like this:

Screenshot 2022-05-16 115652.png

Screenshot 2022-05-16 115711.png

Screenshot 2022-05-16 115734.png

Screenshot 2022-05-16 115749.png

Thanks in advance guys hope somebody could help me.

[gjeremy1617088143]

HI @Nel Andrew​ , maybe you could do something like this : first you read the file and you filter only the data with true (with a tFIlterRow for eg) then you use a tFlowToIterate component and you iterate on each value filtered then you made an inner join with the same file on quoteName field in a tMap.

So for eg here the main flow after the filter on true:

quote1 true

quote2 true

quote3 true

quote4 true

and for each one you will get all the data with tMap join :

eg for quote1 :

quote1 false

quote1 false

quote1 true

FileInput -->main link--> tFilterRow -->filter link --> tFlowToIterate-->iterate link-->

tFixedFlowInput -->main link --> TMap --> FileOutput

FileInput -->lookup link /^

send me love and kudos

[gjeremy1617088143]

here i use tFixedFlowInput 1 and 3 to simulate your input file