Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading three files with different employee types to build a model

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.

1 Reply
denwo2010
Creator
Creator

Hi,

You can do something like the below.

Fact:

Load

'Type A' as Type,

EmployeeNo;

From File1

CONCATENATE

Load

'Type B' as Type,

EmployeeNo;

From File2

CONCATENATE

Load

'Type C' as Type,

EmployeeNo;

From File3