Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Contributor

Re: Loading three files with different employee types to build a model

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

Community Browser