Loading three files with different employee types to build a model

[#1]

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.

[denwo2010]

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