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.

[#2]

Hi Sandeepa,

Do this!

TableA:

Load

     Invoiceno &'_'& week as InvoiceWeek, //Common Key for TableA and TableB

     invoiceno as TableA_Invoice, // Renamed to Avoid SyntheticKey

     week as Week //If you want to connect to TableC-> Week field

From TableA;

TableB:

Load

     Invoiceno &'_'& week as InvoiceWeek, //Common Key for TableA and TableB

     invoiceno as TableB_Invoice, // Renamed to Avoid SyntheticKey

     week as TableB_Week // If this is changed to Week, it will connect to Week in TableC

From TableB;

TableC:

Load

     Week // This can be connected to Week in TableA or TableB as wished

From TableC;

Hope that helps

Sravan

[SunilChauhan]

try the following

tab1:

load

invoiceno,

week as wek_1

from path

left join(tab1)

Load

invoiceno, week

from path

left join(tab1)

load

week

from path

[its_anandrjs]

Hi,

I think u have to load

Tab1:

Load

invoiceno,

week as Tab1_Wk

From Table1

Tab2:

Join(Tab1)

Load

invoiceno,

week as Tab2_Wk

From Tabl2

Tab3:

Join(Tab1)

Load

week

From Table3

Let me know about this

Rgds

Anand

[its_anandrjs]

Hi,

I think your first two tables are already has same column name so i suggest you join them and third table is connect with your week field so that you get data of that table also.

Tab1:

Load * inline

[

invoiceno, week

in1,wk1

in2,wk1

];

Tab2:

Join(Tab1)

load * inline

[

invoiceno, week

in2,wk2

in3,wk2

];

Tab3:

load * inline

[

week

wk3

wk3

];

See attachement

Rgds

Anand

[#6]

Please find attached of the qvw file.

Thanks.

[#7]

Actually TableA and TableB should join by invoice no.

And TablceC should join TableA and TableB by week as I have to reference arrange the data by tableC.Week field.

[SunilChauhan]

take the attached file and reload

hope this will help you

thankss

Sunil

[its_anandrjs · Accepted solution]

Hi,

See the attache file

HTH

Rgds

Anand

[SunilChauhan]

anand,

but it still showing synthetic key.

if u see there is used two join with same table.

sandeepa

did you get the proper result.