It might not make a diiference but I was wondering if there was any efficienies with dropping all resident tables at end of script versus one at a time throughout the script.
I thought the same thing, but then realized that every time a DROP is executed, the TableName() is affected because the table doesn't exist any longer.
I revamped my code above to store the table names in a variable and drop them all at once.
HI LITLE CONFUSION BETWEEN THE STEPS if isnull(d) then i = 250 end if if d <> null() then drop $(d); end if WHAT THESE STEP MEANS WHY YOU USED ISNULL WITH VARIABLE D AND D NOT EQUAL TO NULL AND USED "NEXT" AFTER THIS WHAT WAS THE PURPOSE OF THAT PLEASE REPLY I AM NEW TO QLIKVIEW SO NEED YOUR HELP
WHAT THESE STEP MEANS WHY YOU USED ISNULL WITH VARIABLE D AND D NOT EQUAL TO NULL AND USED "NEXT" AFTER THIS WHAT WAS THE PURPOSE OF THAT PLEASE REPLY I AM NEW TO QLIKVIEW SO NEED YOUR HELP
