Discussion Board for collaboration on QlikView Scripting.
I have a script that loads only new records from a Source table into a QVD. I want to be able to state the # of new rows that are being loaded in a Trace Statement. See below for an example.
TRACE New Rows being loaded;
WHERE NOT EXIST ID;
TRACE "x" rows loaded into Sales;
Go to Solution.
You can use the function NoOfRows(NameOfTable)
After the first load, you assign NoOfRows to a varable, trace the value and do the same after the second load
Let vNumberOfRows = NoOfRows(Sales);
You need to create a Variable like below
Let vNoOfRows = NoOfRows('TableName');
I had to put a If statement to show 0 row if none were added but it worked. Thanks for the quick response.
LET vNumberofRows = IF(LEN(TRIM(NoOfRows('Sales')))=0,0,NoOfRows('Sales'));
Trace $(vNumberofRows) rows added;