Discussion Board for collaboration on QlikView Scripting.
I have inherited a script from a former colleague and there are a some code lines I am confused about; they seem redundant to me:
Step 1: He joins two tables:
load distinct * resident ExcelDetails
Step 2: He creates a new table KEYS_tmp2
NONCONCATENATE LOAD * resident KEYS_tmp
DROP table KEYS_tmp
RENAME TABLE KEYS_tmp2 to KEYS_tmp;
Now, why create KEYS_tmp2 in the first place since nothing is done data wise when loading data into it from KEYS_tmp.
I am pretty new to Qlikview and there's probably a good reason for doing this....
Could anybody in this forum enlighten me?
Thanks in advance
Steps 2 and 3 look to be completely redundant
Hi Prashant - and thank you for the reply 🙂
Yes he joins more tables on the renamed KEYS_tmp.
Why is it not possible to just continue joining to the KEYS_tmp from step1?
Try to add a fake column to the table KEYS_tmp2 :
NONCONCATENATE LOAD * , '1' as Fakecolumn resident KEYS_tmp
DROP table KEYS_tmp ;
drop field Fakecolumn ;
RENAME TABLE KEYS_tmp2 to KEYS_tmp;Let us know if that works 😉
I think if there are no transformations happening in step2, then step2 and step3 are redundant and should be removed.