0 Replies Latest reply: May 10, 2011 11:56 AM by syed maqsood RSS

    Temporary table created after Update SQL

      Hi All,

       

      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!!

       

      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.

       

       

      Screenshot 1: Script

       

      Script - Temp table.JPG

       

      Screenshot 2: Debug Message

       

      Trace - Temp table.JPG

       

      Screenshot 3: Data Model with Temporary Tables created

       

      DM - Temp table.JPG