Import into List - duplicates in key

rosmiller

Hi

I want to import a customer forecast into a module. 

The customer forecast is 

Key, Product, Location, Date, Qty

My end module will have a key dimension which is the Product/Location and dimension time,

with a value of qty.

So part of the import process is to create the key List.

If I import into the key list from the customer forecast file I get duplicates for product/location key for every time period that exists.

I could get round this by creating a key that includes time and create a very big list, and then importing from this into another shorter key list excluding time. But this seems to be creating what should be unnecessary lists/data

Ideally I would like the duplicates when importing into my keys list to not be an error.

Is there any way round this without having to create long lists to then shorten them?

rosmiller

Unfortunately I need to import the data from the customer forecast before I can search for the first occurrence, in which case I need to include the date in the key.

So yes, I can do it like this, but it means I have to have a very large key (including all dates) and then import into another module with a key not including the date. 
Possible, but just seems long winded.

StevenBeerthuizen

You could import the whole list in a numbered list and do the filtering from there (in a module) and then import into your final list?

BR,

Steven

rosmiller

Yes... but I then still have to create a larger list than necessary.

I suppose I really want to be able to ignore the duplicates when I import into the smaller list.

This would be a more efficient process. 

But I accept this is not how Anaplan works.

 

rosmiller

Unfortunately I need to do the process every time I import the customer forecast. So every time I have to create and delete the large list. Which is OK, but inefficient. I accept that this has to be done.