AnsweredAssumed Answered

merge multiple flat file records into one record

Question asked by falk.wiegand@extern.accenture.com on Jun 22, 2017
Latest reply on Jul 17, 2017 by therissa

I've multiple records containing a product name, a date MM-YYYY and the amount of sold items.

i'll now have to combine/map all records of the same product name into one record with the name and 12 columns - one for each month.

Sourcefile looks like this.

Product,Customer,Period,Amount
"Prod1","Cust1","2016-11","10"    => LastYear11
"Prod1","Cust1","2016-12","8"     => LastYear12
"Prod1","Cust1","2017-04","2"      => CurYear04

 

target file has to be like this

Product,Customer,LastYear11,LastYear12,CurYear01,CurYear02,CurYear03,CurYear04
"Prod1","Cust1","10","8","0","0","0","2"

 

I have to map the value of column Period to the appropriate column in the target file.

Outcomes