on 2018 Nov 23 11:19 AM
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Nazeer
do you have any blogs which gives step by step. I have the same requirement
Appreciate your help
thanks
Chitti Mutyala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
49 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.