Discussion board where members can get started with QlikView.
I need to connect 2 tables, but my problem is that I don't know how to create this key, as
only 1 parameter is found in both tables, the second parameter is coming out of a third table.
The situation causes a circular reference as shown in attached picture.
Does anybody know how I can avoid this ? I have (as a beginner) no idea at all how I could create
a usefull key with these 3 tables..
Thanks for your help.
Rename one Kred.-Nr.
hope this helps
I did not explain good enough.
I need a key with "EINECS"+"Kred.-Nr." from table 1 to table 3.
The problem is that I only get the "EINECS" for the "Item No_" in table 3
out of table 2.
this would solve your pupose
if any concern let me know
Join any one table with the other one and make unique key between the joined table and the table 3.
Like join Products All DataS and Item by EINECS and delete the Item table.
Make a unique by joining Kred.-Nr with ItemNo in both the table.
Hope this helps.
Thanks for your help, this works.