Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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
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
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