You have two possible solutions in QlikView/Qlik Sense.
You could join your tables together using JOIN LOAD.
//This code will generate the green table in the picture below Transactions: LOAD * FROM Supplier.qvd (qvd); //Yellow data in picture JOIN (Transactions) LOAD * FROM Customer.qvd (qvd); ////Blue data in picture
Alternative you could choose to generate a concatenated transaction table. Stacking the data into the same table resulting a data table similar to the combined blue/yellow table in the picture
//This code will generate the blue/yellow table Transactions: LOAD * FROM Supplier.qvd (qvd); //Yellow data in picture CONCATENATE (Transactions) LOAD * FROM Customer.qvd (qvd); //blue data in picture
The third option is to keep the two tables as they are, two seperate tables. You'll get a syntetic key that you don't need to worry about, or you could eliminate the syntetic key by replacing the two Date and Order-fields with an composite key eg
LOAD: Date & '|' & Order AS %Key, Supplier FROM Supplier.qvd (qvd); LOAD Date & '|' & Order AS %Key, Customer FROM Customer.qvd (qvd);
Hi Thanks for the info below -
I'm having some problems trying to solve this issue - i Should have mentioned in my original post -
Table 1 - comes from Microsoft SQL Server
Table 2 - Comes from Excel spreadsheet
I have created another Excel Spreadsheet that merges the supplier name from Table 2 to match with Table 1 -
Supplier(Table2)Customer Description Company Description SupplierName(Table 1) F001-Aldi Aldi Aldi
F065 - APS Produce
Aps Produce Aps Produce F041 - Lactalis Lactalis McLelland Ltd Lactalis McLelland Ltd F061 - Castle MacLellan Primula Primula
As the above table shows the customer Discription will not always match SupplierName.
So i have 3 tables that i need to join.