Importing data from .csv files

Can you please explain how should I import the .csv File at the mapping stage?

How do i know what options to select under the SOURCE dropdown? what logic it uses so that the data can be displayed as desired in the model.

I am trying to import the subset file however it is a bit confusing as to what i should select in parent, code, etc.

thanks

Anaplan_-_EXAMPLE_LEVEL_1_MODEL_ARCHITA_108888.pdf

Accepted answers

All comments

Misbah

@Archita

You will have to load E1 list before E2 List gets loaded. Assuming that you have already uploaded E1 list. you can map

E1 list against Parent

Code against Code

and rest all from respective columns.

Also make sure that you base your import on Codes. Meaning on the right side of the import window where it is asking "Items Uniquely Identified by" select Code and NOT Name or Concatenation of Properties

Hope that helps

Misbah

Archita

thank you so much. i will try that

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…