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
Screenshot 2: Debug Message
Screenshot 3: Data Model with Temporary Tables created