L2 Sprint 1 - 1.3.10.2 Import Data into G2 Country List

trust you can provide guidance here. What am I doing incorrectly here? Please share.

Task request: 1.3.10.2 Import Data into G2 Country List In the Data Hub model, import data from the source saved view into the target list: Source: SYS06 Country Details module, Build Country saved view Target: G2 Country list NOTE: This list is part of the geographic hierarchy. Remember to designate the Parent when importing the data.

Situation: I cannot get the country upload - from saved module view to list with the appropriate hierarchy setup.
It can be mapped manually and I'd still like to understand what am I doing incorrectly. Appreciate if you can share your wisdom and experience.

SYS05 Module Saved View:

SYS06 Module Saved View:

G1 Region List:

G2 Country list before the upload (populated automatically after loading G1 Region List):

Import Mapping:

Import errors:

G2 Country list after the upload:

Many thanks.
Br,

Tom

G2_Country_list_after_the_upload_128208.jpg

G2_Country_list_before_the_upload__128208.jpg

SYS05_128208.jpg

Import_Mapping_Errors_128208.jpg

Import_Mapping_128208.jpg

G1_Region_List_128208.jpg

SYS06_Module_128208.jpg

Accepted answers

All comments

JaredDolich

@Tom1407

Hey Tom, looks like you're really close. You did everything correctly but I'm wondering if your G2 Country list is set up correctly. G2 Country is part of the "Try it" hierarchies so the need to have their parent/child set up. Make sure it looks like this:

HarshaR

What is your parent hierarchy in G2 Country List, can you please check the configure tab for country list. Looks like your parent hierarchy may not be correct. The parent hierarchy for G2 Country list should be G1 Region.

Tom1407

Hi @JaredDolich

here it is.

G1 region - all regions.

G2 country - G1 region

G3 locations - G2 country.

Many thanks.

Br,

Tom

Tom1407

Hi @HarshaR ,

here it is:

Br,

Tom

JaredDolich

@Tom1407

Ah, okay! I see the issue. For G1, you have Region CODE for both the name and the Code. You need to load the "Name" into G1 Region first. You'll be all set! Like this:

Tom1407

@JaredDolich

as SYS05 is feeding G1 Regions - how did I break that? I used saved view and loaded into regions.

Did I incorrectly map it? If I did, am I wrong in my assumption that Anaplan would flag that as incorrect?

Module seems to be accurate:

JaredDolich

@Tom1407

Your flat list is fine. It's your G1 List "Try It" that needs to be adjusted. This is the image you shared:

Rebuild this list making sure the Code is only used once and for "Code" Use the Region description for the "Name" . You got this!

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…