Level 1 Training: Unable to load data in Employees module

Options
amit15
amit15 Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Extensibility

Hi Guys,

I am following level 1 training, but at the step 7.2.3 Activity: Import Data into Employee Details Module, I am unable to load data as it is shown in the snapshots.

The issue is E2 Employees# list is a numbered list, so getting confused on its mapping with the target module. Second thing is the source file has country code, but the module is shown populated as country name after the import. Can you please help how it is happening? 

Attaching the files for reference. 

Expected Output:

amit15_0-1623046039978.png

 

My Mappings:

amit15_1-1623046105081.png

amit15_2-1623046128660.png

 

What should I select in source for numbered list coz taking employee column, it throws error and if I do not select anything, then it does not let me run the import.

amit15_3-1623046938772.png

 

 

 

Tagged:

Comments

  • amit15
    amit15 Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks @Misbah for your response! This worked.

     

    But can you help me understand the logic behind this? How does this work?

    And while data import, does anaplan by default maps the code with list elements? e.g. in the file, we have dept and country code, and I manually mapped these codes with respective lists. But in the cube while populating data, it populated actual country and departments, not their codes. How does it work?

     

    Thanks in advance!

Categories