Hi All,
I was trying to load data into a module, but my data file has duplicate rows.
when I load the file, I was expecting the duplicate rows to be ignored or flagged as duplicate record value but it getting added in the member value.
Example:
Dimension Line item(amount)
row1 ABC 10
row2 DEF 20
row3 ABC 30
row4 DEF 40
When I load the above file, my values for ABC becomes 40(10+30) and DEF becomes 60(20+40)
Is this is the way anaplan will load a data file or is there any way I can eliminate the duplicate rows.
Regards,
Usha
Solved! Go to Solution.
Simple!!!
Get the data as 'Text' and then convert that to 'Number'. So in this way, only the first occurrence will be loaded and the other will be ignored. I hope this helps!
Regards,
Kavin.
Hi Usha,
You don't need the FIRST OCCURENCE to applies kavin's solution. when we load data into the text format line item, the system will take the first unique record only and ignore the duplicate records., So You don't need the FIRST OCCURENCE.
To implement my solution, Yes, you need staging modules.
Let say you have 3 data loading modules, then you need 3 staging modules.
Regards,
Vignesh M