Importing Excel data to a module by using hierarchical list

msta

Hello Anaplan community,

 

I would like to import data from Excel source to a module using a hierarchical list. 

In my data Excel source, I do not have the column Parent, which will helps me to import data with the specific list.

 

Let's imagine I have an hierchical list that contains 3 subset lists : A, B and C. 

In my data source file, I have differents rows that belongs to one of the three lists : A, B and C.

I must not edit my data source file and there is no Parent column in the source file saying wich row belongs to which list. 

How can I import my data source rows in the module accoding to my hierchical list A,B,C ?

Is it possible to affect a Code to the 3 sub lists and then mapping my data according to this code ?

 

Thanks for your answers in advance !