topic Temporary table created after Update SQL in QlikView https://community.qlik.com/t5/QlikView/Temporary-table-created-after-Update-SQL/m-p/287966#M711801 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have observed that a temporary table is being created in QlikView, when we execute Update statement soon after a Drop field command. Not sure if other users have come across the same situation and found a work around to fix it in script!!</P><P></P><P>I have no errors or issues in my script. Its just that this temporary table is misleading and does'nt do any good to the data model.</P><P></P><P></P><P>Screenshot 1: Script</P><P></P><P><IMG alt="Script - Temp table.JPG" class="jive-image-thumbnail jive-image" height="314" onclick="" src="https://community.qlik.com/legacyfs/online/4098_Script+-+Temp+table.JPG" width="897" /></P><P></P><P>Screenshot 2: Debug Message</P><P></P><P><IMG alt="Trace - Temp table.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/4099_Trace+-+Temp+table.JPG" width="450" /></P><P></P><P>Screenshot 3: Data Model with Temporary Tables created</P><P></P><P><IMG alt="DM - Temp table.JPG" class="jive-image-thumbnail jive-image" height="383" onclick="" src="https://community.qlik.com/legacyfs/online/4106_DM+-+Temp+table.JPG" width="706" /></P></BODY></HTML> Tue, 10 May 2011 15:56:48 GMT 2011-05-10T15:56:48Z Temporary table created after Update SQL https://community.qlik.com/t5/QlikView/Temporary-table-created-after-Update-SQL/m-p/287966#M711801 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have observed that a temporary table is being created in QlikView, when we execute Update statement soon after a Drop field command. Not sure if other users have come across the same situation and found a work around to fix it in script!!</P><P></P><P>I have no errors or issues in my script. Its just that this temporary table is misleading and does'nt do any good to the data model.</P><P></P><P></P><P>Screenshot 1: Script</P><P></P><P><IMG alt="Script - Temp table.JPG" class="jive-image-thumbnail jive-image" height="314" onclick="" src="https://community.qlik.com/legacyfs/online/4098_Script+-+Temp+table.JPG" width="897" /></P><P></P><P>Screenshot 2: Debug Message</P><P></P><P><IMG alt="Trace - Temp table.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/4099_Trace+-+Temp+table.JPG" width="450" /></P><P></P><P>Screenshot 3: Data Model with Temporary Tables created</P><P></P><P><IMG alt="DM - Temp table.JPG" class="jive-image-thumbnail jive-image" height="383" onclick="" src="https://community.qlik.com/legacyfs/online/4106_DM+-+Temp+table.JPG" width="706" /></P></BODY></HTML> Tue, 10 May 2011 15:56:48 GMT https://community.qlik.com/t5/QlikView/Temporary-table-created-after-Update-SQL/m-p/287966#M711801 2011-05-10T15:56:48Z