Suppressing duplicates while importing list
Within a module, we have line items for entity, employee, currency, and account, with the module being dimensioned by time (month). The employee's entity and currency may change monthly. Additionally, there's another line item called Key, formed by concatenating the aforementioned four line items, and its time scale is also monthly due to the variability of both entity and currency on a monthly basis.
The problem emerges during the Key import, triggering an error message that reads, "Another row has already been processed with this key." Moreover, the ISFIRSTOCCURRENCE does not provide assistance in this case, as its time scale has to set to monthly and remains true for all months. Can anyone provide guidance on obtaining unique values when importing the list
Answers
-
I would flag IFO for the month first then your other combination, that way it will become a unique record for the list item to populate.
0 -
Thanks for the response. We already have IFO by month but not working in this case. Could you suggest if this can achieved in any other way.
0 -
Can you include ITEM(time) in your key text? That way you will get new keys each month you- if still doesn't work share some screen grabs here pls
0 -
When time is included in the key, it ensures uniqueness, but it also results in a significantly larger list. Based on the "Model Performance Report" from Anaplan, we removed time from the key.
0 -
Its a module with only time and line items, right?
Can you share how the key is being calculated? and share the module data where it has duplicates for two months?
You were using IFO with Time right. it must be like IFO(Key, Time)?
0 -
You may generate key only for months where you have values and get blanks for 0 value cells
0
