Discussion Board for collaboration on QlikView Layout & Visualizations.
Can someone tell me how to remove synthetic key for below scenario? I should not use link table, Table concatenate, Table Join.
Create a composite key instead..
Customer_ID&'|'&Store_ID AS link_Key,
Use Qualify , Disqualify
In the Weekly_Fact table and Monthly_Fact table use Autonumber(Locatio_ID , Store_ID) and create the
composite key and give alias name as Key.
Remove Store_ID field from Weekly_Fact table .
Remove Location_ID field from Monthly_Fact table .
So there will be 2 fields in Weeky_Fact "Key" & "Location_ID" .
and there will be 2 fields in Monthly_Fact "Key" & "Store_ID" .
Location_Dimension table will be linked to Weekly_Fact table
Store_Dimension table will be linked to Monthly_Fact table.
You can remove synthetic key by the following ways.
1. using JOIN
2. using CONCATENATE
3. rename fieldnale
4. using Qualify
I would also suggest to use Qualify and Unqualify
Concatenate in fact tables.
drop field or rename fields with as