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?