Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

store system fields

Hi all,

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

thanks

J

1 Reply
sbaldwin
Partner - Creator III
Partner - Creator III

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;