This content has been marked as final. Show 4 replies
I'm trying to show the number of rows in a load script. It works when I wirte directly the name of the table in the function noOfRows, but is does not if I use a variable (for every other purpose the variable works).
Here a sample
SET TABLE_NAME_03 = Monthly_Sales;
let Rows_in_structure = NoOfRows($(TABLE_NAME_03)); => This line returns always NULL
let Rows_in_structure = NoOfRows('Monthly_Sales'); => This line returns the correct number of rows.
Does anybody knows how to use variable with the function NoOfRows?
Thank for your help