Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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
Please find attached of the qvw file.
Thanks.
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.
take the attached file and reload
hope this will help you
thankss
Sunil
Hi,
See the attache file
HTH
Rgds
Anand
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.