Import to numbered List

Hi People,

I want to import transactional data into the model from excel csv file.

I formed a numbered list, where I am importing this csv file, identifying the unique key by using a combination of properties, but there are other columns that are not forming part of the combination. (basically, those are values/number formatted columns). In this way, I am forced to import the values columns also in the list properties.

Question: Therefore, If I try to go by PLANUAL way, Is there a way by which I do not import values column in list properties, but rather in Module Lineitems?

Welcoming inputs

Accepted answers

AdamCookson

Hi,

I think I see the issue you're running into. What you need is something that correctly ties your data together. There are a few ways to achieve this. The quickest would be to import all properties into the list and then reference them out to a module:

These would then be more visible and easier to reference for other modules.

A more robust solution would be to create a UID that ties your data together. However, you would need to have this within your data source. For example, with a UID your import to the list would look like this:

You can then use this code to import to the module:

If you're able to make changes to the source data I would definitely recommend using some form of unique ID to tie your data together within Anaplan.

Hope this helps

All comments

AdamCookson

Hi,

You'd normally achieve this by having two separate import actions. One to load your unique ID into the numbered list then another to load the same data into an attribute module that you've setup to accept the other properties. Then you can tie both of these actions together in a single process.

Hope this helps.

anupgade

Hi @AdamCookson

As per your solution, How would I map the dimension in a module through an import file?

Let's take an example:

If I load this into a numbered list, my unique key would be column SKU & Country using a combination of properties.

How can I load column Volume & Sales Amount directly in a module lineitem instead of list property ?

AdamCookson

Hi,

These would then be more visible and easier to reference for other modules.

You can then use this code to import to the module:

If you're able to make changes to the source data I would definitely recommend using some form of unique ID to tie your data together within Anaplan.

Hope this helps

anupgade

Thanks @AdamCookson for the solution

But I was also thinking anyother way, where user would not need to create key in the source file.

connectionssports

Beyond the fun, Connections sports helps sharpen cognitive skills. You're giving your brain a workout by challenging yourself to find patterns and think critically about word relationships. Plus, it’s a great way to expand your vocabulary and learn something new daily.

So next time you play, take your time, think creatively, and enjoy the satisfaction of cracking those challenging word groups. Happy solving!

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…