Count rows in a table

[HPW]

Hi,

While downloading tables from our ERP into qvd files I want to count the number of rows for each table.  The number of rows and a timestamp are added to a separate table as log file.  I'm working with variables for the download. Each table is having different columns. Which function can I use to count the rows of the ERP table not having a column name?

SET vtable = CONTRCLASS;
$(vtable):
SQL SELECT *
FROM admin.$(vtable);
STORE $(vtable) INTO $(vtable).qvd (qvd);

Concatenate(ImportLog) LOAD
'$(vtable)' as Table,
????????????? as RowNumbers,
Now() as Timestamp
AUTOGENERATE(1);

DROP table $(vtable);

[rwunderlich · Accepted solution]

NoOfRows('$(vtable)') as RowNumbers

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[HPW]

Worked well. Thanks!