topic Re: Importing file into flat lists in Academy & Training https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/125747#M3529

I encountered the same problem. The source file contains the "parent column". When I imported the file, it does not allow me to keep the parent column blank. 

 

huyenngo_0-1638227365780.png

what should I choose in the yellow highlighted part?

 

Thanks a ton! 

Mon, 29 Nov 2021 23:09:47 GMT huyenngo 2021-11-29T23:09:47Z Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/76653#M2092

I was trying to import data from country CSV to a country flat list.

but since the format of the source file was such that parent needs to be entered while importing or else it is throwing error.

Due to which imported data comes as hierarchy and not as flat list.

Please help with this.

Fri, 10 Jul 2020 20:09:33 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/76653#M2092 kunal_311 2020-07-10T20:09:33Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/76730#M2099

 

 

What error are you getting? In order for you to create a flat list you need to ignore mapping for Parent and map Code and Name.

Mon, 13 Jul 2020 08:14:32 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/76730#M2099 Misbah 2020-07-13T08:14:32Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/76796#M2105

Hello  

By definition, a Flat List doesn't have a parent. If you are importing into the list shown in your file LVL 2 FLAT.jpg then you are importing into the wrong list.
Scroll down the list page in your model until you see the separator ----Flat Lists ----, these are the Flat Lists to which you should be importing the data from the csv files.

Later on, you will use a process to build the hierarchy Region > Country > Location

 

image.png

Mon, 13 Jul 2020 17:55:22 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/76796#M2105 einas.ibrahim 2020-07-13T17:55:22Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/78149#M2168

I am still getting error

 

sguptatalkingrain_0-1595640284879.png

Can anyone help on this error?

Sat, 25 Jul 2020 01:25:07 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/78149#M2168 sguptatalkingrain 2020-07-25T01:25:07Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/78150#M2169

got the solution. You only need to import the country name in country flat as column1.

Sat, 25 Jul 2020 01:52:07 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/78150#M2169 sguptatalkingrain 2020-07-25T01:52:07Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/125747#M3529

I encountered the same problem. The source file contains the "parent column". When I imported the file, it does not allow me to keep the parent column blank. 

 

huyenngo_0-1638227365780.png

what should I choose in the yellow highlighted part?

 

Thanks a ton! 

Mon, 29 Nov 2021 23:09:47 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/125747#M3529 huyenngo 2021-11-29T23:09:47Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/139154#M4223

Same issue here..

The list is under the "Flat Lists" but Anaplan doesn't let me proceed without assigning a parent.

What can I do now?

Sun, 05 Jun 2022 04:37:17 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/139154#M4223 cuneydyasin 2022-06-05T04:37:17Z
Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/139155#M4224 press backspace in the box (instead of selecting from drop down) to make the parent option blank.. It will solve your problem Sun, 05 Jun 2022 04:41:53 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/139155#M4224 vsumanthreddy 2022-06-05T04:41:53Z Re: Importing file into flat lists https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/139156#M4225

Thanks a lot. Can't believe it could be that easy..

Sun, 05 Jun 2022 04:44:07 GMT https://community.anaplan.com/t5/Academy-Training/Importing-file-into-flat-lists/m-p/139156#M4225 cuneydyasin 2022-06-05T04:44:07Z