Level 2 Sprint 1 List Import Errors

When I imported flat files for Sprint 1 1.3 I did not include a parent as instructed, so my country list has only a code, and my location list likewise (see image). However, when I then import this list into G2 Country, it now has no parent listed under region. When I try to write a PARENT(ITEM(___)) formula, I receive errors, bc the SYS05 Region Details does not have a list of children. So when I import the list, there is no hierarchy and it simply looks like the attached.

What am I doing wrong here?

Country_List_Example_153740.PNG

G2_Country_153740.PNG

Accepted answers

All comments

rishi8118

in SYS05 Region Details Module, can you please try this: CODE(ITEM(Region Flat)). Also before applying the formula, it would be better if you could delete the previous hierarchy and import a fresh one in G2 Country list.

Kanishq17

Hi @PSeaworth

The Region is parent for country , so when importing you need to map code to code and Region as parent for the country , then when you use parent() you can get the region item

PSeaworth

It still isn't working after deleting G2. I get the attached error now.

New_Error_153931.PNG

PSeaworth

But when I do this the list is no longer flat.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…