Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

omyahamburg
Contributor II

How to connect 2 tables

Hello all

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.

best regards

Joerg

2 tables.gif

6 Replies
SunilChauhan
Esteemed Contributor

How to connect 2 tables

Rename one Kred.-Nr.

hope this helps

omyahamburg
Contributor II

How to connect 2 tables

Dear Sunil

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.

Thank you.

omyahamburg
Contributor II

Re: How to connect 2 tables

Dear Sunil

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.

Thank you.

SunilChauhan
Esteemed Contributor

How to connect 2 tables

Rename one Kred.-Nr.

this would solve your pupose

if any concern let me know

hope this helps

How to connect 2 tables

Hi,

     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.

Celambarasan

omyahamburg
Contributor II

Re: How to connect 2 tables

Dear Celambarasan

Thanks for your help, this works.

Best regards

Joerg