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

[former_member594071]

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?

[former_member423067 · Accepted solution]

Hello Kumar,

1. use "Select Distinct Rows" in filters to get all unique records in the step 1.

2. then use Row Generate option to create duplicate rows of the incoming records based on the no of times you need. (in your case 3.)

3. Row generate will duplicate the records 3 times and Row ID will be created as 1,2,3 for each duplicates

4. then use formula for date as KFDATE+(ROWID * 7)

This should give your expected output.

with regards,

Nazeer

[cmutyala]

hi Nazeer
do you have any blogs which gives step by step. I have the same requirement

Appreciate your help

thanks

Chitti Mutyala