New to Qlik! How can I put in 3 v. similar data sources?

[#1]

Hi everyone!

We are new to QlikView and are having some difficulty inputting data. We have 3 very similar data sources and have to build a simple data model. We are confused as so many field names are the same across all 3 data sources. We are wondering what the best way to create linkages is? Many thanks!

[Gysbert_Wassenaar]

Try concatenating the data from the three sources into one table:

Data:

LOAD *, 'Source1' as Source FROM source1;

Concatenate(Data)

LOAD *, 'Source2' as Source FROM source2;

Concatenate(Data)

LOAD *, 'Source3' as Source FROM source3;