Load scritpts function NoOfRow with variable as tablename
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
SETTABLE_NAME_03 = Monthly_Sales;
$(TABLE_NAME_03): LOAD *
FROM $(TABLE_NAME_03)_2016.qvd (qvd)
letRows_in_structure = NoOfRows($(TABLE_NAME_03)); => This line returns always NULL letRows_in_structure = NoOfRows('Monthly_Sales'); => This line returns the correct number of rows.
Does anybody knows how to use variable with the function NoOfRows?