Loop through a list of all loaded tables

[alan_grn]

I am trying to loop through a list of loaded. What si the best way to do this.

I have been trying to use

LET

NoofTables = NoOfRows('$Table');

TO get how many tbale sare loaded, but this doe snot return a value.

[#2]

hi alan,

use the nooftables() function instead of noofrows()

let x=nooftables();

this should work and it will give u the no of tables loaded so far.

thanks

[alan_grn]

Thanks this works.

How do I then look through the $table table to get the table name?

[#4 · Accepted solution]

hi alan,

you can either create a list box with $Table as field to see the names of the table or use

let x=tablename(1);

it will give the name of the 1st table loaded

similarly,

let x=tablename(2); will give the name of the 2nd table loaded

thanks

[alan_grn]

Thanks this works.

I could not find these functions in the help file. Is ther any documentation on them?

[#6]

hi alan,

you can refer the QlikView Reference manual in C:\Program Files\QlikView\Documentation directory

thanks