L2 Sprint 1 - 1.3.10.2 Import Data into G2 Country List

Options
Tom1407
Tom1407 Member, ALL USERS Posts: 5 Occasional Contributor
in Extensibility

Hi @JaredDolich 

 

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:

Tom1407_0-1640267641884.png

 

SYS06 Module Saved View:

Tom1407_1-1640267641885.png

G1 Region List:

Tom1407_2-1640267641887.png

 

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

Tom1407_3-1640267641889.png

 

Import Mapping:

Tom1407_4-1640267641890.png


Import errors:

Tom1407_5-1640267641892.png

G2 Country list after the upload:

Tom1407_6-1640267641893.png

Many thanks.
Br,

Tom

Tagged:

Comments

  • HarshaR
    HarshaR Member, ALL USERS, Employee Posts: 5 Occasional Contributor

    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
    Tom1407 Member, ALL USERS Posts: 5 Occasional Contributor

    Hi @JaredDolich 

     

    here it is.

    G1 region - all regions.

    G2 country  - G1 region

    G3 locations - G2 country.

    Tom1407_0-1640272701990.png

    Many thanks.

    Br,

    Tom

  • Tom1407
    Tom1407 Member, ALL USERS Posts: 5 Occasional Contributor

    Hi @HarshaR ,

     

    here it is:

    Tom1407_0-1640272841187.png

    Br,

    Tom

  • Tom1407
    Tom1407 Member, ALL USERS Posts: 5 Occasional Contributor

    @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:

    Tom1407_0-1640276184211.png

     

Categories