AnsweredAssumed Answered

Separating head and detail information from single CSV.

Question asked by SunilRanagaswamy8251 on Oct 22, 2015
Latest reply on Oct 26, 2015 by Adam Arrowsmith

I am getting single file with header and detail information as in attached document, where header information is repeated(header filed 1,4,5) for all detail lines. For example if an invoice has 5 detail lines, header information is repeated for all 5 lines.

What I need is, split the single file into 2 files one for headers and another for lines.

Now I need 2 files, one is for Header which will contains 2 lines with header filed 1,4,5 and sum of lines amount for individual invoice and another file with detail information other than 1,4,5 fields.

Outcomes