Import List Hierarchies

Hello Everyone,

I am attempting to load a list hierarchy through an import file (example below).

I have close to 800 locations so as you can imagine manually structuring the hierarchy isnt an option . I have tried setting up the headers and in the Grid View and assiging parents of each column header, but the location names dont automatically go into a hierarchical list.

Does anyone know how I can get the list hierarchy to show up automatically when I import the entire file so it looks like below...

-Global Location

---Europe Location

-----United Kingdom Location

--------England Location

-----------London Location

Accepted answers

All comments

janani.prabhu

Hi,

You can create the seperate lists of Global Location,Europe Location,UK Location, England Location,London Location.Then you can create hierarchies in that list and can import files.

Regards,

Janani

leo_tadjudin_1

Hi Krutland,

Is it possible to arrange the list into 3 columns info: Name, Code and Parents?

Anaplan will automatically build the hierarchy accordingly without you have to break it into multiple column by Level. This is if you are trying to make the hierarchy as Flat hierarchy.

If you want to make it into Composite hierarchy, all you need to do is run the import (name, code, parent) per level with other level as Parent. You can use the link below as reference

Employees L5, is assigned a parent, Sub-Depts L4.
Sub-Depts L4 is a child of Departments L3.
Departments L3 is a child of Region L2.
Region L2 is a child of Geo L1.

https://community.anaplan.com/t5/Modeling/List-Hierarchies/ta-p/12364/jump-to/first-unread-message

Hope it helps.

Thanks,

Leo

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385