Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resolving Synthetic keys

seeing below example, is it possible to remove synthetic keys?

synthetic key.JPG.jpg

5 Replies
MayilVahanan

Hi

Create a key by combining the "GSK SKU ID" and "Distributor_Code" using Autonumber and use that to link btw DS2-Sales.xlsx and DS1-Stocks.xlsx

Thanks & Regards,
Mayil Vahanan R
Anonymous
Not applicable
Author

provide new key to connect between Sales and Stocks

Sales:

load

[GSK_SKU_ID] & Distributor as %Key

..

from ... Sales.xlsx

Stocks:

Load

[JDE_Code],

[Distr Code],

[JDE_Code] & [Distr Code] as %Key

..

from .. Stocks.xlxs

Donot use as for JDE Code and Distr Code as otherwise new syntetic key will be created

or use qualify and unqualify for stocks

MK_QSL
MVP
MVP

Keep [GSK SKU ID] and Distributor_Code in your sales table but Remove [JDE Code] and [Distr Code] from your another table...

Create a key in Sales and another table..

[GSK SKU ID] & '|' & Distributor_Code as Key

and

in another table

[JDE Code] & '|' &[Distr Code] as Key,

simondachstr
Luminary Alumni
Luminary Alumni

Have a look at this blog post:

Qlik Tips: Update to Link Table rules

sujeetsingh
Master III
Master III

One can not say that is it possible to remove the Synthetic key. One can easily rename them and remove it.

But the concept lies is your data model. Do it needs that

----You have do decide and control the linkings of these keys.

----Use composite keys to work on...

----Properly analyse the association  of data your UI presentation and calculations need.

--