Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
Partner
Partner

Re: store system fields

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;