Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

poooja
New Contributor III

Synthetic key

Hi Qliks,

I am trying to remove the synthetic key here and also need to find the below solution. Have also attached the QV file.

Capture.JPGCapture1.JPG

1 Solution

Accepted Solutions
Partner
Partner

Re: Synthetic key

My first question to ask is. Which columns are necessary in the Order table in order to identify the correct record(s) in the Shipped table. Create a composite key from these fields, e.g. AutoNumberHash256(Dimension1, Dimension2, ..., DimensionN) as %Key

All duplicate columns names need to be removed or renamed so the only shared field name is the %Key field.
Please ekskuse my Norglish and Swenglish typos.
1 Reply
Partner
Partner

Re: Synthetic key

My first question to ask is. Which columns are necessary in the Order table in order to identify the correct record(s) in the Shipped table. Create a composite key from these fields, e.g. AutoNumberHash256(Dimension1, Dimension2, ..., DimensionN) as %Key

All duplicate columns names need to be removed or renamed so the only shared field name is the %Key field.
Please ekskuse my Norglish and Swenglish typos.