NN relationship

[Anonymous]

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

[RedSky001]

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?

[#3 · Accepted solution]

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

[Anonymous]

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