Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
here i use tFixedFlowInput 1 and 3 to simulate your input file