Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi,

Create a composite key instead..

Customer_ID&'|'&Store_ID AS link_Key,

Regards,

Highlighted
Not applicable

Use Qualify , Disqualify

Highlighted
Not applicable

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

Highlighted
Not applicable

You can remove synthetic key by the following ways.

1.     using JOIN

2.     using CONCATENATE

3.     rename fieldnale

4.     using Qualify

Highlighted
Contributor II
Contributor II

I would also suggest to use Qualify and Unqualify

Highlighted
Contributor III
Contributor III

Concatenate  in fact tables.

and/or

drop field or rename fields with as