Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
-Mark
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