Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove Synthetic Key

Hi,

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

Syn_key.png

6 Replies
vivek_niti
Partner - Creator
Partner - Creator

Hi,

Create a composite key instead..

Customer_ID&'|'&Store_ID AS link_Key,

Regards,

Not applicable
Author

Use Qualify , Disqualify

Not applicable
Author

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

Not applicable
Author

You can remove synthetic key by the following ways.

1.     using JOIN

2.     using CONCATENATE

3.     rename fieldnale

4.     using Qualify

Anonymous
Not applicable
Author

I would also suggest to use Qualify and Unqualify

Anonymous
Not applicable
Author

Concatenate  in fact tables.

and/or

drop field or rename fields with as