Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Contributor

Re: How to remove Synthetic Key

Hi,

Create a composite key instead..

Customer_ID&'|'&Store_ID AS link_Key,

Regards,

Not applicable

Re: How to remove Synthetic Key

Use Qualify , Disqualify

Not applicable

Re: How to remove Synthetic Key

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

Re: How to remove Synthetic Key

You can remove synthetic key by the following ways.

1.     using JOIN

2.     using CONCATENATE

3.     rename fieldnale

4.     using Qualify

rakeshparikkalk
New Contributor

Re: How to remove Synthetic Key

I would also suggest to use Qualify and Unqualify

hdbucher
New Contributor III

Re: How to remove Synthetic Key

Concatenate  in fact tables.

and/or

drop field or rename fields with as

Community Browser