system fields

[srihitha]

Below system fields are not returning values for me. Can someone pls check

Channel:
LOAD * inline [ Name,Age
Sri,21
hish,35];

tagmap:
load *,'$(Table)';
LOAD * inline [

a,b

Alpha,MyTag

Num,MyTag

];

Trace $(Table);

Table	Contains all tables that are loaded.
$Field	Contains all fields in the tables that are loaded.
$Fields	Contains the number of fields in each table.
$FieldNo	Contains the position of the fields in the tables.
$Rows	Contains the number of rows in the tables

[micheledenardi · Accepted solution]

According with documentation, System Fields can be used only in visualizations, not in load script.

System fields 

[vchuprina]

Hi,

They are system fields, not variables.

You are using an undefined variable Table,  for this reason, you have empty space instead of a value

Channel:
LOAD * inline [ Name,Age
Sri,21
hish,35];


tagmap:
load *,
     'tagmap' as Table;
LOAD * inline [
a,b
Alpha,MyTag
Num,MyTag
];

LET Table = Peek('Table', 0, 'tagmap');

Trace $(Table);

Regards,

Vitalii

[vinieme12]

Can you explain what exactly is your use case?

If you want to loop over. Existing tables you can refer the snippet from help section below

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/TableFu...