Skip to Content
0
Nov 23, 2018 at 11:19 AM

How to replicate a record multiple times in CPI-DS?

1829 Views Last edit Nov 26, 2018 at 05:13 AM 2 rev

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?