Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a NN join with 3 tables. I can't find how to load the data in qlikview so that it works.
The tables are "Relation", "Delivery_Points" and "Services"
Here is the description of the join :
[Relation]TableSource= 123 (table number [Delivery_Points])
[Relation][Relation]SourceField= 12 (Field number [Delivery_Points]Number)
[Relation]TableDest=29 (Table number [SERVICES])
[Relation]FieldDest = 1 (Filed number [SERVICES]Number)
If anyone can help...
Cheers,
Clement
I'm not sure i undersand your description of the join,
but I think for a NN join you use the prefix 'FULL OUTER JOIN' before your 2nd and 3rd LOAD
Can you provide some example of data from each of the three source tables and an example of how you are expecting the output to look in Qlikview?
I'm not sure i undersand your description of the join,
but I think for a NN join you use the prefix 'FULL OUTER JOIN' before your 2nd and 3rd LOAD
Sorry guys,
I was given the wrong information by the DBA.
It worked fine with simple links when I had the right information...
Thanks for answering.
Clement