topic Re: Synthetic tables when loading from resident tables in QlikView https://community.qlik.com/t5/QlikView/Synthetic-tables-when-loading-from-resident-tables/m-p/912388#M986668 <HTML><HEAD></HEAD><BODY><P>If the synthetic key is not causing performance problems then don't remove it. See this discussion: <A href="https://community.qlik.com/thread/175410">how to remove syn table</A></P></BODY></HTML> Wed, 05 Aug 2015 15:20:13 GMT Gysbert_Wassenaar 2015-08-05T15:20:13Z Synthetic tables when loading from resident tables https://community.qlik.com/t5/QlikView/Synthetic-tables-when-loading-from-resident-tables/m-p/912387#M986667 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hi,</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">My question is when loading from resident tables and then transforming data, like in a crosstable script, you will end up with synthetic keys; in order to keep disk space low what is the opnion of developers?</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">I would like to keep the relationships but remove the syn key what is the best way?</SPAN></P><P> </P><P>[CT2]:</P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">CROSSTABLE</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field2</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Value2</SPAN><SPAN style="font-size: 8pt;">,5)<BR /></SPAN><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">LOAD</STRONG></STRONG><SPAN style="font-size: 8pt;"> <BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">[abc123]</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">[def123]</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN></SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">FirstValue</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[ID]</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[ID]</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">RESIDENT</SPAN><SPAN style="font-size: 8pt;"> [Orion CSV Download]<BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">group</SPAN><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">by</SPAN><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;">[abc123]</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">[def123]</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;">[ID]</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">; </SPAN></P><P></P></BODY></HTML> Wed, 05 Aug 2015 14:46:38 GMT https://community.qlik.com/t5/QlikView/Synthetic-tables-when-loading-from-resident-tables/m-p/912387#M986667 tinkerz1 2015-08-05T14:46:38Z Re: Synthetic tables when loading from resident tables https://community.qlik.com/t5/QlikView/Synthetic-tables-when-loading-from-resident-tables/m-p/912388#M986668 <HTML><HEAD></HEAD><BODY><P>If the synthetic key is not causing performance problems then don't remove it. See this discussion: <A href="https://community.qlik.com/thread/175410">how to remove syn table</A></P></BODY></HTML> Wed, 05 Aug 2015 15:20:13 GMT https://community.qlik.com/t5/QlikView/Synthetic-tables-when-loading-from-resident-tables/m-p/912388#M986668 Gysbert_Wassenaar 2015-08-05T15:20:13Z