How to solve the synthetic key problem?

[#1]

Hi,

I have problems in synthetic key. How I can remove the synthetic key in my QLikview?

The data I pull from sharepoint are from different lists, The RAE, CWF and the Intern are from 3 different list.

Can anyone helps me with this?

Regards,

KAma

[simenkg]

Concatenate them together.

Employees:

Load *,

          'RAE' as EmployeeType

from RAE.qvd (qvd);

Concatenate (Employees)

Load *,

        'CWF' as EmployeeType

from CWF.qvd (qvd);

Concatenate (Employees)

Load *,

     'Intern' as EmployeeType

from Intern.qvd (qvd);

[#3]

Hi,

Where should i put the Concatenate?