Sorry but i did not get what you are trying to do above specially after Link Table. Why you load same data twice with where not exist clause because i think key = Dim1 & '_' & Dim2 & '_' &Dim3 because Dim1 & '_' & Dim2 & '_' &Dim3 AS Key,
Sorry, Typing mistake. Link table is used whenever we have multiple dimensions in two or more fact tables. When we load this in Qlikview Synthetic keys will be formed, with synthetic keys the performance would be affected, so avoid this Link table is one of the technique, other than link table we can also use Concatenate.
Sample of using multiple dates and letting the user decide what date to use.
You have an Invoice table and a Orders table. Both have a date field and you would like to have only one set of date fields on your sheet (f.i. Year, Month, Day). You load (concatenate both) the key plus the date from each table, plus an indicator ('Invoice" AS Type; 'Order' AS Type) into a link table and rename the date to a single date field (f.i. Invoice_Date AS Link_Date; Order_Date AS Link_Date). You also have acalender wher the date is renamed (or copied) to that link date (Calendar_Date AS Link_Date). Now you can use the Calender fields to select either Order dates or Invoice dates. The field Type is used to determine what dates are being used.
Something like this ...
Invoice:
%KEY_Invoice,
Invoice_Date,
...
Order:
%KEY_Order,
Order_Date,
...
LINK:
LOAD
%KEY_Invoice,
Invoice_Date AS Link_Date,
'Invoice' AS Type
RESIDENT Invoice;
CONCATENATE
%KEY_Order,
Order_Date AS Link_Date,
'Order' AS Type
RESIDENT Order;
Calendar:
Year,
Month,
Quarter,
Date,
Date AS Link_Date,
...
Invoice and Orders link to the LINK table and the LINK table links to the Calendar table.
