Discussion board where members can get started with Qlik Sense.
I have three files of employee types.
File 1 has type A employees responses which I need to load through crosstable.
File 2 has type B employees responses which I also need to load into the model through crosstable.
File 2 has type C employees responses which some are similat to type B and has to also be loaded into the model through crosstable
These type A , B & C employees have different responses.
My challenge is how do I load all of them into the model through APPENDING. EmployeeNo is the only field common on three files however employees are distinct in 3 files.
You can do something like the below.
'Type A' as Type,
'Type B' as Type,
'Type C' as Type,