Level 1 Lesson 7, activity 7.2.4



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?