topic Script function to get the name of the most recent table loaded? in QlikView

Script function to get the name of the most recent table loaded?

Fri, 03 Feb 2012 19:40:49 GMT

Hi all,

Is there a function that will tell me the name of the most recent table in the load script? For example:

Table1:

Load * from

SQL select * from orders;

Table2:

Load * from

SQL select * from customers;

let a = LastTableLoaded(); // would return "Table2"

Thanks!

swuehl — Fri, 03 Feb 2012 21:44:12 GMT

Let vTableName = TableName( NoOfTables()-1 );

Mon, 06 Feb 2012 14:33:06 GMT

Exactly what I was looking for. Thanks!