topic Re: How to connect 2 tables in QlikView

How to connect 2 tables

omyahamburg — Fri, 27 Jan 2012 07:49:13 GMT

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

How to connect 2 tables

SunilChauhan — Fri, 27 Jan 2012 08:00:45 GMT

Rename one Kred.-Nr.

hope this helps

How to connect 2 tables

omyahamburg — Fri, 27 Jan 2012 08:22:20 GMT

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.

Re: How to connect 2 tables

omyahamburg — Fri, 27 Jan 2012 08:22:55 GMT

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.

How to connect 2 tables

SunilChauhan — Fri, 27 Jan 2012 08:26:21 GMT

Rename one Kred.-Nr.

this would solve your pupose

if any concern let me know

hope this helps

How to connect 2 tables

CELAMBARASAN — Fri, 27 Jan 2012 09:10:42 GMT

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

Re: How to connect 2 tables

omyahamburg — Fri, 27 Jan 2012 09:23:31 GMT

Dear Celambarasan

Thanks for your help, this works.

Best regards

Joerg