Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion
Partner - Champion

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