topic How to solve the synthetic key problem? in QlikView https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819203#M1040606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have problems in synthetic key. How I can remove the synthetic key in my QLikview?</P><P></P><P><IMG alt="sync.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73290_sync.PNG" style="height: 463px; width: 620px;" /></P><P>The data I pull from sharepoint are from different lists, The RAE, CWF and the Intern are from 3 different list. </P><P>Can anyone helps me with this?</P><P></P><P>Regards,</P><P>KAma</P></BODY></HTML> Fri, 12 Dec 2014 01:50:17 GMT 2014-12-12T01:50:17Z How to solve the synthetic key problem? https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819203#M1040606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have problems in synthetic key. How I can remove the synthetic key in my QLikview?</P><P></P><P><IMG alt="sync.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73290_sync.PNG" style="height: 463px; width: 620px;" /></P><P>The data I pull from sharepoint are from different lists, The RAE, CWF and the Intern are from 3 different list. </P><P>Can anyone helps me with this?</P><P></P><P>Regards,</P><P>KAma</P></BODY></HTML> Fri, 12 Dec 2014 01:50:17 GMT https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819203#M1040606 2014-12-12T01:50:17Z Re: How to solve the synthetic key problem? https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819204#M1040607 <HTML><HEAD></HEAD><BODY><P>Concatenate them together. </P><P></P><P>Employees:</P><P>Load *,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'RAE' as EmployeeType</P><P>from RAE.qvd (qvd);</P><P></P><P>Concatenate (Employees)</P><P>Load *,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'CWF' as EmployeeType</P><P>from CWF.qvd (qvd);</P><P></P><P>Concatenate (Employees)</P><P>Load *,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 'Intern' as EmployeeType</P><P>from Intern.qvd (qvd);</P></BODY></HTML> Fri, 12 Dec 2014 02:00:06 GMT https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819204#M1040607 simenkg 2014-12-12T02:00:06Z Re: How to solve the synthetic key problem? https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819205#M1040608 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Where should i put the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Concatenate?</SPAN></P></BODY></HTML> Fri, 12 Dec 2014 02:26:41 GMT https://community.qlik.com/t5/QlikView/How-to-solve-the-synthetic-key-problem/m-p/819205#M1040608 2014-12-12T02:26:41Z