Search code examples
etltalendtalend-mdm

Any solutions on splitting output file?


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...

File of Example

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: output example

output example output example

Thanks in advance guys, hope someone could help me.


Solution

  • I would try this :

    tFileInputExcel -> main -> tReplicate -> main -> tFilterRow (quoteName equals quote1 ) -> tlog

                                       -> main -> tFilterRow (quoteName equals 
                                       quote2 
                                                 ) -> tlog 
                                      -> main -> tFilterRow (quoteName equals quote3 
                                                 ) -> tlog 
                                      -> main -> tFilterRow (quoteName equals quote4 
                                                 ) -> tlog 
    

    Or using a tMap component would do the staff using filtering optin in the output