Synthetic key

[poooja]

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.

[Vegar · Accepted solution]

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.