store system fields

Anonymous — Mon, 28 Oct 2013 09:08:25 GMT

Hi all,

how can i store the system fields ( $Table,$Row,$Fields) into a table in the script?

thanks

Re: store system fields

sbaldwin — Mon, 28 Oct 2013 12:15:33 GMT

Hi, you could add something like this to the end of your script: (only done for table and fields but you could make use of the other system functions to add the remainder, like NoOfRows etc.

Thanks

Steve

let ix = NoOfTables()-1;

for i= 0 to $(ix)

let table_name = TableName($(i));

let jx = NoOfFields('$(table_name)');

for j= 1 to $(jx)

let column_name = FieldName($(j),'$(table_name)');

system:

load * inline [

t,f

$(table_name),$(column_name)

];

next j;

next i;

topic store system fields in QlikView

store system fields

Re: store system fields