topic Re: Union of two or more tFileOutputDelimited File in Talend Studio

Union of two or more tFileOutputDelimited File

Anonymous — Wed, 30 Jan 2013 14:23:33 GMT

Hi,
I have output in more than one file output delimited file. Now I want to append them together (union) to form a single tFileOutputDelimitedFile
So for example if we have
tFileOutputDelimitedFile_1
ACCT_NBR;CHANNEL;Value
1;Other _Debit_Sum;62.65
1;Internet_Debit_Sum;0.0
tFileOutputDelimitedFile_2
ACCT_NBR;CHANNEL;Value
1;Other _Credit_Sum;32.0
1;Internet_Credit_Sum;20.0
We want the final output to be
ACCT_NBR;CHANNEL;Value
1;Other _Debit_Sum;62.65
1;Internet_Debit_Sum;0.0
1;Other _Credit_Sum;32.0
1;Internet_Credit_Sum;20.0

Re: Union of two or more tFileOutputDelimited File

janhess — Wed, 30 Jan 2013 15:43:24 GMT

Use tUnite.

Re: Union of two or more tFileOutputDelimited File

Anonymous — Thu, 31 Jan 2013 12:32:06 GMT

Hi Amit,
Use the following steps to get our desired output:
1) Use three tFileInputDelimited component to get the input form three different files
Note: To automate the above step for N-number of input file you can use tFileList Component before tFileInputDelimited Component
2) Double Click the component to get the properties dialog box, give the appropriate location of the file & set the proper Field Separator
3) Right Click on all the three tFileInputDelimited Component and select row --> main and drop it in to the tUnite component
4) tUnite component will union all the incoming rows from three files
5) Connect to the tLogRow or your target component
For clear understanding have a look on the attached snapshot.
Best Regards,
Mayur