Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find name of resident tables

HI,

is there any way to find number and name of all resident tables?

Regards,

Saurabh

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In script,

NoOfTables()  returns the number of tables.

TableName(n)  returns the name of Table n.

-Rob

View solution in original post

2 Replies
Colin-Albert

The system fields will give these details.

$Table Displays all internal tables loaded by the script.

$Field Displays the fields that are in the table.

$Fields The count of fields in the table

$FieldNo This shows the position of the fields in the table.

$Rows This shows the number of rows in the table.

You will need to enable Show System Fields to see these values.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In script,

NoOfTables()  returns the number of tables.

TableName(n)  returns the name of Table n.

-Rob