How to relate sub-region under regions

Tsuyoshi_Inoue1

Hi Experts,

I have problem in importing data again.

Could you tell me how to map data Sub-Regions under Regions?

For example NOAM > US North > Anderson, Janet

Kindly see what is expected and what it is now in my screen.

thanks in advance.

Regards,

Tsuyoshi

<<What is expected>>

無題.png

<<This is my screen now>>

無題.png

Accepted answers

All comments

DavidSmith

@Tsuyoshi_Inoue1

Can you include a screenshot of the file you are importing. It looks like the parent mapping for people is on the wrong column - Region instead of sub region

David

Tsuyoshi_Inoue1

Hello David,

Thanks for your quick response.

This is what I want to import.

無題.png

DavidSmith

You will need to create the lists for Regions and Sub-Regions before importing the Reps

1. Create the Regions list mapping Region as Name and Geo as parent

2. Create the Sub Regions list mapping Sub-Region as Name and Region as parent

3. Create the Reps list mapping Sales Rep as Name, Rep Code as Code, and Sub Region as parent

Also, a couple of Best Practice points

1. if you can try and get additional columns for codes for the Geos, Regions, Sub Regions

2. Also, the naming convention should be x1 Geos, x2 Regions, x3 Sub Regions, x4 Sales Rep. The x could be G to signify a Geographic hierarchy or S for Sales Rep

I hope this helps

David

Tsuyoshi_Inoue1

Hello David,

"1. Create the Regions list mapping Region as Name and Geo as parent" do you mean this when "insert into general list" or "import excel file into region list"?

Regards

Sheethal

He meant it while importing the file into the Region list. But for this to work, you should already have the Region List created with Geo as the parent & Geo list should have been already populated with its list members like NOAM, EMEA, APJ, etc.

Tsuyoshi_Inoue1

Thank you all!

I tried along your kind advice.

again, I encountered another error.

>2. Create the Sub Regions list mapping Sub-Region as Name and Region as parent

I tried this. But "New York" isn't under "US East".

Any help is appreciated.

無題.png

Sheethal

Please post the screenshot of your import mapping.

Tsuyoshi_Inoue1

Hello Sheethal,

this is a screenshot for my importing screen.

As you can see, sub region for name, and region for parent are mapped.

無題.png

Sheethal

Mapping seems to be fine. But did you get any errors in the "Result Summary" after the import?

Tsuyoshi_Inoue1

There occurred "Another row has already been processed with this key " error as in the screenshot.

無題.png

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
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…