Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

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
Highlighted
Partner
Partner

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post