Level 1 Lesson 7, activity 7.2.4

ShirleyV

Hi,

I followed the course instruction to build the module SYS08 Employee Details and import data for Employee.csv.

'Code' and 'Name' and 'Dept' not loaded, then I tried to insert formula as suggested for 'CODE' and 'DEPARTMENT' but there was error message 'E2 EMPLOYEE#' is not recognized as a hierarchy in the model.  The ITEM function should take a hierarchy as argument. 

=> Then I mapped 'Name' and 'Dept' and so now 'Dept' and 'Name' are filled but 'Code' not filled.  

 

Is there anyone knows was there error when I created the system module or what steps was wrong?

 

wskagegard

Hi! 

 

Are you sure you have imported the code into the 'E2 Employees' list?  Should look like below. 

 

 

ShirleyV

Hi,

 

Thanks for reply.  Yes, I did but strangely it did not map the code.

 

 

wskagegard

CAn you show me your function in the code line item? 

ShirleyV

I can't find the 'function'. Here are the screenshot for 'SYS 08 EMPLOYEE DETAILS' and module showed 'functional area'.  Or please let me know where I shall look for it.

 

wskagegard

For the code line item in SYS08 there you need to have the function. CODE(ITEM('E2 Employee'))

wskagegard

 

ShirleyV

Thanks a lot! Now it is working.  Before when I copy the formula from the training material it always prompt with error message said not recognized as a hierarchy but now I input manually and now it is working. 👍