7.2.3 Activity: Import Data into Employee Details Module

Hi Team,

In the Level 1 Model Builder activity 7.2.3 Activity: Import Data into Employee Details Module , do we have to manually map mappings for E2 Employees between source and target items ? Is there any way for the mappings of E2 Employees ?

Please help as it is very lengthy process to do the manual mappings for 111 emp.

E2_Emp_mappings_101376.PNG

Accepted answers

JaredDolich

@abhinandan

@Misbah and @andre.lie are correct. You should use Code. Re-download the employee.csv file and do not edit it in Excel. Sometimes if you open the .csv and resave it, Excel will interpret "009" as "9" and it won't map correctly. Try again! You've got this.

All comments

andre.lie

@abhinandan , we don't need to map them manually. You can use employee code instead of name.

abhinandan

Hi Thanks for the reply.

I tried with code also, but even with code , mappings for E2 are not getting mapped automatically. PFA screenshot for the same.

It will accept and work as per the image attached for employees ?

E2_Mappings_101384.PNG

Misbah

@abhinandan

Since Employees is a numbered list it has to be mapped to Code as suggested by @andre.lie . However codes need to be exactly matching between the Source and Target. See if this helps

Check if you have codes matching between Data Hub and Spoke Model, it can "001" or Just "1" but it has to be same and matching at both these places

abhinandan

Hi Misbah,

Thanks for your inputs.

However I am not able to map all the 2 digit numbers for employees (code 1 to code 99), from 100 onwards its getting mapped automatically. So for 99 employees its getting failed and for rest 12 emp data is getting loaded.

How to map codes for first 99 employees ?

PFA Emp mapping , Line items mapping, Error and Output of model. Kindly help !

E2_code_mappings_101393.PNG

error_101393.PNG

Output_101393.PNG

Line_Item_Mappings_101393.PNG

JaredDolich

@abhinandan

DaanishSoomar

Yes @JaredDolich mentioned,

Having consistent code syntax will help your data flow through. You are indeed very close!

Sumair

This solved my issue ..thanks!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…