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