topic Re: Resolving Synthetic keys in QlikView

Resolving Synthetic keys

Fri, 20 Nov 2020 18:02:30 GMT

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

MayilVahanan — Fri, 05 Sep 2014 10:08:28 GMT

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

Anonymous — Fri, 05 Sep 2014 10:12:09 GMT

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 — Fri, 05 Sep 2014 10:19:02 GMT

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 — Fri, 05 Sep 2014 10:22:20 GMT

Have a look at this blog post:

sujeetsingh — Fri, 05 Sep 2014 10:23:23 GMT

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.