Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Synthetic Key Issue

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.

1 Solution

Accepted Solutions

Re: Synthetic Key Issue

Hi,

See the attache file

HTH

Rgds

Anand

13 Replies
Not applicable

Re: Synthetic Key Issue

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

chauhans85
Esteemed Contributor

Synthetic Key Issue

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

Re: Synthetic Key Issue

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

Re: Synthetic Key Issue

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

Not applicable

Re: Synthetic Key Issue

Please find attached of the qvw file.

Thanks.

Not applicable

Re: Synthetic Key Issue

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.

chauhans85
Esteemed Contributor

Re: Synthetic Key Issue

take the attached file and reload

hope this will help you

thankss

Sunil

Re: Synthetic Key Issue

Hi,

See the attache file

HTH

Rgds

Anand

chauhans85
Esteemed Contributor

Synthetic Key Issue

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.

Community Browser