topic Re: How to remove Synthetic Key in QlikView

How to remove Synthetic Key

Sun, 26 May 2013 02:54:14 GMT

Hi,

Can someone tell me how to remove synthetic key for below scenario? I should not use link table, Table concatenate, Table Join.

vivek_niti — Sun, 26 May 2013 05:14:21 GMT

Hi,

Create a composite key instead..

Customer_ID&'|'&Store_ID AS link_Key,

Regards,

Mon, 27 May 2013 04:12:20 GMT

Use Qualify , Disqualify

Mon, 27 May 2013 05:00:59 GMT

HI,

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.

Regards

Yusuf

Mon, 27 May 2013 05:21:27 GMT

You can remove synthetic key by the following ways.

1. using JOIN

2. using CONCATENATE

3. rename fieldnale

4. using Qualify

Anonymous — Sat, 17 Mar 2018 14:15:15 GMT

I would also suggest to use Qualify and Unqualify

Anonymous — Sun, 18 Mar 2018 20:28:26 GMT

Concatenate in fact tables.

and/or

drop field or rename fields with as