How to split a file into header and details

Anonymous — Mon, 30 Mar 2020 18:56:28 GMT

I am working with a csv file that I would like to split into two tables of header and details. An Invoice would be a good example of this where there are multiple invoice headers and each invoice header has multiple line items. However, in the original source file the header information repeats for all of its lines.

Original File

Header_UniqueID
Header_SellerName
Header_BuyerName
Line_UniqueID
Line_Item
Line_QTY
Line_Price

Output

Header Table
- Header_UniqueID
- Header_SellerName
- Header_BuyerName
Line Table
- Line_UniqueID
- Header_UniqueID (reference to record in the header table)
- Line_Item
- Line_QTY
- Line_Price

I've searched the other forum posts, but not finding what I was looking for, but maybe im not using the correct working in my searches. I've also looked at the tNormalize/Demormalize components, but I dont think that is what I need either.

Re: How to split a file into header and details

TRF — Mon, 30 Mar 2020 19:20:42 GMT

Use a tMap with 2 output flows, 1 for headers and 1 for lignes.
Connect 1rst output flow to a tUniqRow to eliminate duplicates, then to the desired output file or table.
Connect the 2nd output flow to the desired output file or table.

topic How to split a file into header and details in Talend Studio

How to split a file into header and details

Re: How to split a file into header and details