AnsweredAssumed Answered

merge multiple flat file records into one record

Question asked by 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.

"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



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