Use Case and Workaround:
I am trying to import data into numbered list using "Combination of Properties" option. The catch is, my only unique identifier is "Month". I have records for a GL Account by Cost Center by Product and by Location. And will have same combination coming in as Trial Balance records but for different months.
If you see below the highlighted rows 1 and 3 the only way they are uniquely identified is by the month in which the entry is passed ( Jan 18 and Feb 18).
GL Account | GL Account Name | Month | Cost Center | Product | Location | Amount (USD) | Tagged Project Code | Tagged Project |
5000-01 | ABC | 18-Jan | XYZ1000 | Product A | INDIA | 10 | Default | Default |
5000-01 | ABC | 18-Jan | XYZ1000 | Product B | INDIA | 20 | Default | Default |
5000-01 | ABC | 18-Feb | XYZ1000 | Product A | INDIA | 160 | Default | Default |
5000-01 | ABC | 18-Feb | XYZ1300 | Product A | INDIA | 170 | Default | Default |
5000-01 | ABC | 18-Feb | ABC1000 | Product B | INDIA | 180 | Default | Default |
While importing I was getting error "Another row has already been processed with this key".
Anaplan fails to evaluate the Month value while importing.
Workaround: Before importing I added a column CODE which was concatenation of GL Account , Cost Center , Product and Location and Month. Then while importing I used this CODE as numbered list's code. Please note the month was converted to numeric value by excel and hence I was able to identify them uniquely.
Hope this helps and saves time of rebuild.
Thanks,
Jensit