Synthetic Key Issue

[#1]

Hello All,

I am using Qlikview9.

In my qlikview model I have three tables A, B, C.

In A: invoiceno, week

In B: invoiceno, week

In C: week

If I will join these three tables it is giving me a synthetic ..

Please suggest how to avoid it...

Thanks.

[its_anandrjs]

Hi,

Thanks, I am not able to reload your file but there is two join for two tables see the codes once

Join(TableA)

and

Join(TableB)

It works correctly

Rgds

Anand

[#3]

Yeah. Synthetic key is still showing.. But I managed to get the output. As it is a kinda circular join can't avoid synthetic key...

[its_anandrjs]

Hi,

Thanks, Ok great rename that field or delete perticular field i suggest there is more than two fields that are connected to each other or also there is key between then unfortunately you have to delete atleast one field from table which makes circular reference.or you want to keep that field rename it or qualify that field with

Qualify Fieldname;

Rgds

Anand

[SunilChauhan]

sounds good

keep it up both of you anand and sandeepa