Importing file into flat lists

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.

LVL_2_FLAT_76653.jpg

Lvl_2_flat_1_76653.jpg

lvl_2_flat_2_76653.jpg

Comments

Misbah

@kunal_311

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.

einas.ibrahim

Hello @kunal_311

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

sguptatalkingrain

I am still getting error

Can anyone help on this error?

sguptatalkingrain

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

huyenngo

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.

what should I choose in the yellow highlighted part?

Thanks a ton!

cuneydyasin

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?

vsumanthreddy

press backspace in the box (instead of selecting from drop down) to make the parent option blank.. It will solve your problem

cuneydyasin

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

SindhuKK

I am encountering aa error while importing the SKU flat file,

Import the data file into the SKU Flat list in the Data Hub model.
Remember this is a flat list. Only include the item name and Code. There should not be a parent assigned.

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…