Hi Team,
As we know on usingsecond parm to autonumber -- the "autoid" to ensure your values are sequential when autonumbering more than one field, will also help the symbol table optimization."
I have a long, concatenated, composite key generated Using Autonumber() with autoid and based on all the discussion happened in qlik community regarding autonumber and its effect on symbol table i understood the symbols will take no space in the symbol table.
below is the part of code i am using in my script (col name not disclosed)
tabl1:
load*,
autonumber(columnA & columnB,'Key1') as Encryption_key,
autonmuber(column C & '_'& columnD,'Key2') as %email
from database tabe1;
left join(tab1)
tab2:
load *,
autonumber(columnA & columnB,'Key1') as Encryption_key
from database table2;
But when i started analyzing the memory statics from document properties i could see the symbol table taking space as shown in below attachment:
please let know if my understating is right , and also let me know why in the below snap the symbol table is taking space on using autonumber with auto id
