Count rows in a table

HPW — Thu, 13 Jan 2022 15:06:51 GMT

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);

Re: Count rows in a table

rwunderlich — Thu, 13 Jan 2022 15:56:24 GMT

NoOfRows('$(vtable)') as RowNumbers

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

Re: Count rows in a table

HPW — Fri, 14 Jan 2022 06:54:28 GMT

Worked well. Thanks!

topic Re: Count rows in a table in QlikView

Count rows in a table

Re: Count rows in a table

Re: Count rows in a table