L1 Model Building Activity 6

tspoon
edited January 2023 in Academy Discussions

How would I go about adding Department and Role to SYS08? I don't believe that was a part of the exercises which I followed step by step. This is what I have for my SYS08:

 

Screen Shot 2022-03-15 at 5.54.40 PM.png

 

I have Department and Country...

Tagged:

Answers

  • Department can be imported via .csv file as a part of exercise.

    If you want to add the department by using formula, first format the line item as List: Department; then as Department is the upper level of hierarchy in the Employee list, Department can be written as PARENT(ITEM('E2 Employee List)