I have three sets of data all with the dimension 'Reference Number', all the files contain some reference numbers which are the same and some different ones, each with other dimensions.
I need to load the first file then left join the two other sets of data but limiting the 'Reference numbers' in the first set of data.
load "Reference Number", "Item Number"
left join (table1)
load "Reference Number", "Part Number"
load "Reference Number", "Unit Number"
load * Inline [
Reference Number, Item Number
Reference Number, Part Number
Reference Number, Unit Number
Thank you but it doesn't seem to work as the second left join doesn't appear to work?
Im not sure its joining to the first table?
How is this:
different of this?
Omars example is very easy but ok.
In your datas it could happen that there are more joins than you want.
Qlik is joining tables by same field names automatically, so be sure fields you want to join have same namens, you don't want different.