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...
-----United Kingdom Location
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.
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
Hope it helps.