Information on Symbol table

nagarajuabhi — Wed, 25 Nov 2020 16:16:04 GMT

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

topic Information on Symbol table in QlikView

Information on Symbol table