Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
NoOfRows('$(vtable)') as RowNumbers
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
NoOfRows('$(vtable)') as RowNumbers
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Worked well. Thanks!