Question:
How to replicate a record as per its unique plant and location combination 3 times and incrementing the value of keyfigure date by 7days for each record?
Requirement:
Data in source file:
LOCID PRDID KEYFIGUREDATE YIELD
ABC 100 11/23/2018 11
XYZ 101 01/01/2019 12
Data required in IBP:
LOCID PRDID KEYFIGUREDATE YIELD
ABC 100 11/23/2018 11
ABC 100 11/30/2018 11
ABC 100 12/07/2018 11
XYZ 101 01/01/2019 12
XYZ 101 01/08/2019 12
XYZ 101 01/15/2019 12
How can we get this kind of output for only unique LOCID and PRDID in CPI-DS?