https://community.qlik.com/t5/QlikView/Synthetic-key/m-p/1562167#M742238 <P>Hi Qliks,</P><P>I am trying to remove the synthetic key here and also need to find the below solution. Have also attached the QV file.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 916px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8985i276D88D3051DDD95/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 631px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8986i22C3AB8DB2D5D1EA/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.JPG" alt="Capture1.JPG" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT poooja 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Synthetic-key/m-p/1562167#M742238 <P>Hi Qliks,</P><P>I am trying to remove the synthetic key here and also need to find the below solution. Have also attached the QV file.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 916px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8985i276D88D3051DDD95/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.JPG" style="width: 631px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8986i22C3AB8DB2D5D1EA/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.JPG" alt="Capture1.JPG" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Synthetic-key/m-p/1562167#M742238 poooja 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Synthetic-key/m-p/1562247#M742240 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<BR /><BR />All duplicate columns names need to be removed or renamed so the only shared field name is the %Key field. Thu, 28 Mar 2019 07:36:21 GMT https://community.qlik.com/t5/QlikView/Synthetic-key/m-p/1562247#M742240 Vegar 2019-03-28T07:36:21Z