Re: Importing Excel data to a module by using hierarchical list
Are you able to attach an example of what the source data looks like?
Typically, when I'm bringing in data from an outside source, I like to set up a list of records to load the data against. This way you can load the data into Anaplan in the same format that it is in your file. You'd set up a new list of Records, load in the Records, and then load all other columns to module line items. From there, you could add line items to the module where you can write rules to read the data and act on certain things. Next, you can set up an import from saved views of this data to populate your actual lists. Lastly, you can group these three actions (1 to Records list, 1 to Records Detail module, and 1 to your actual list) into a process that can all be run together.