topic Split output file in Talend Studio

Split output file

NAndrew1652694287 — Fri, 15 Nov 2024 22:55:13 GMT

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.

Re: Split output file

gjeremy1617088143 — Mon, 16 May 2022 13:01:42 GMT

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 true

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

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

FileInput -->lookup link /^

send me love and kudos

Re: Split output file

gjeremy1617088143 — Mon, 16 May 2022 14:02:54 GMT

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