Discussion Board for collaboration on QlikView Scripting.
I have a scenario where I have 2 KPIs, both of them derived using separate queries,
The combination of Key1 and Key2 would be the primary key.
Now I need to join Query 1 and Query 2 with other queries, 10 of them. 10 needs to be joined with either KPIs.
Whats the best way to create the data model?
May be we can follow many ways, I am assuming
Load *, Key1 & Key2 as PrimaryKey from Query1;
Load *, Key1 & Key2 as PrimaryKey from Query2;
Load *, AutoNumberHash128(Key1, Key2) as PrimaryKey;
Load Year, Month, Key1, Key2, KPI1 from Query1;
Load Year, Month, Key1, Key2, KPI1 from Query2;
Load Year, Month, Key1, Key2, KPI1, 'Query1' as Flag from Query1;
Load Year, Month, Key1, Key2, KPI1, 'Query2' as Flag from Query1;
Or, Link table also easy way
Thanks Anil. How can I use a link table here?
Hope this helps and if you got answer please close this thread
Load DISTINCT *, PrimaryKey Resident Query1;
Load DISTINCT *, PrimaryKey Resident Query2;
Drop fields Key1, Key2 from Query1, Query2;