Numbered Lists import

Hi, I am trying to import transaction data into a module. To represent each individual transaction, I want to use a numbered list. Also, since there are many transactions in the csv, I want Anaplan to automatically identify and create the required no. of transactions in the numbered list. How can I import and create this form of automated list? My csv doesn't have a unique identifier column and has duplicates which I want to place as separate items on the numbered list.

Accepted answers

PrevContributor

Hi Shreyak,

You should be able to do this without any changes to the import by setting the import unique identifier as Combination of Properties where you identify a set of columns that combined will become your unique identifier. When it comes to Transactions we typically see a good combination of unique properties to be any of the following: Transaction Date + Customer Name/ID + Product + Transaction Amount.

It is important that your load to the Numbered List ONLY include the Code. Then run a second import of the actual data into your module, so this would be 2 loads, ideally run through a Process.

Let me know if you'd like more details, hope this helps!

-Chris Weiss

All comments

PrevContributor

harish_bk

Hi Shreyank if the size is not an issue we have an option:

1) Create Counter list list with the number of rows and list item name being 1,2,3 so on
2) Have these numbers in each row of the csv and map it

If size is an issue then we can just have a module with multiple line items all list formatted and then the counter list and then import accordingly, then you can use sum funciton and make the reporting modules accordingly

PrevContributor

Hi,

Thanks for the reply.

I was able to create the numbered list and import the transactions in the list using the 'Combination of Properties'. However, when I go to the module where I want to do the second import of the transaction data, I am unable to map the data based on the 'Combination of properties'. I am able to select one of the columns to import but since the values in a single column can be ambiguous I am unable to do the import to the module.

Do you know a workaround for this problem with the import to the module?

PrevContributor

Hi Shreyak,

Good point, sorry I didn't provide more context around that. You have a few options at this point, glad you were able to get the original List import to work though:

[list=1]
Add a unique identifier to your original source file (depending on the source system though this is usually not a realistic request),
After importing your List items, you can extract them back to Excel, and merge your it into your original file, which will provide the CODE to your original source file for use in your Module import, or
You can just import all the attributes of the source file into the List as List Properties, which is typically not recommended for performance issues but in this case you may not have any other options.
Hope that helps, let me know if you'd like more details!

-Chris Weiss

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…