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