Split file to more files in talend

talend
Betlista picture Betlista · Apr 27, 2012 · Viewed 7k times · Source

I'm looking for a way how to split job execution in talend studio according to actual file row - I'd like to process file rows starting with "DEBUG" in one job branch and another rows in another job branch. It that possible?

Answer

user1483583 picture user1483583 · Jun 26, 2012

To do this, use a tMap component. Your job will look like this

   t*Input--row-->tMap--out1--->tFileOutput*

                      --out2--->tFileOutput*

In the tMap component, you have input on the left and output on the right. In your output table, select "Activate expression filter" and use the text box to define your filter-- only rows that match that filter will be ouput from that connection. You can have as many output tables and filters as you need.

Related questions

Insert throws SQLCODE: -180, SQLSTATE: 22007 on IBM DB2

I'm using a data integration tool (Talend) to insert some rows on a IBM Db2, but the following command throws an error: INSERT INTO "TOTCHQ" ("CODREM","NUMDOCC8","NOMPES","NUMBAN","CODAGEBN","QTDCHQDL","DATULTOA") VALUES ('3080',99999999999,'FULANO DE TAL',100,'0000',2,…

Read More
How to add third party libraries to Talend project?

How to add third party libraries (jar files) to a Talend project ? One more question is, Each Talend component uses LogFactory, but in my case it is throwing java.lang.NoClassDefFoundError: org.apache.commons.logging.LogFactory at ... with tSetGlobalVar component, …

Read More
Need to Get the current DateTime in the Talend Studio?

I am working the Talend studio tool for data migration. Now I want to set the Current DateTime in the Date field. I get the DateTime from this code TalendDate.getDate("yyyy-MM-dd HH:mm:ss") but it returns String type …

Read More