Discussion Board for collaboration on QlikView Scripting.
I saw that Link tables are include in the Qlikview Best Practices, so I have read various explanations and I thought I would try to create a basic scenario.
I have created the following tables:
LOAD * INLINE [
Then looking at a 'template' to create the link table:
%KEY_FACT1_ID AS %KEY_LNK_ID
, %KEY_DIM1_ID AS %%KEY_DIM1_ID
, %KEY_DIM2_ID AS %%KEY_DIM2_ID
%KEY_FACT2_ID AS %KEY_LNK_ID
, %KEY_DIM1_ID AS %%KEY_DIM_ID
I created the following (amoungst numerous other attempts!):
The result is horrible. Can someone explain where I am going wrong, or is it just a bad example?
, %Key & %Colour & %Size as %comb_key
DROP FIELDS %Key , %Colour ,%Size FROM Table1;
DROP FIELDS %Key , %Colour ,%Size FROM Table2;
View solution in original post
inorder to create a linked data model follow the below steps:
autonumber(x,'table1') as key1,
autonumber(g,'table2') as key2,
autonumber(r,'table3') as key3,
drop fields y,z from Table1;
drop fields y,z from Table2;
drop fields y,z from Table3;
you can see all the tables 1,2,3 combined into one table and its field key1, key2,key3
linked to respective table1 , table2, table3 and each individual tables has distinct dimension fields
and therfore no circular loop will form,
Thanks very much. I appear to have missed the point about creating a combined key.
Your result certainly looks alot better than mine!