I recall from working with qlik a long time ago that different datasources join automatically while uploading in the dataload editor. Though I currently can't find the button with which you can do the automatic join. And is it also possible to specify in the automatic join, which file you want to have as the main datafile, which type of join you want and based on which values you want to join?
The data is not joined automatically, but associated automatically.
In QlikView and Qlik Sense this association is done by field names. If you load two tables with a common field name then the twondata sets will be linked/associated through that field.
Example:
You load sales data
LOAD customer_id, Date, Product, Quantity, Amount FROM Source;
And you load a customer register...
LOAD customer_id, [Customer name], [Customer adress] FROM customerSource;
Then your Sales and Customer data will be automatically associated through their common field customer_id.
The data is not joined automatically, but associated automatically.
In QlikView and Qlik Sense this association is done by field names. If you load two tables with a common field name then the twondata sets will be linked/associated through that field.
Example:
You load sales data
LOAD customer_id, Date, Product, Quantity, Amount FROM Source;
And you load a customer register...
LOAD customer_id, [Customer name], [Customer adress] FROM customerSource;
Then your Sales and Customer data will be automatically associated through their common field customer_id.
