Discussion Board for collaboration on QlikView Scripting.
I understand that Mapping table is hard coded table and we can simply count number of row manually. But Is it possible to get row count of the mapping table by using Qlikview?
For example table below:
Mapping LOAD * Inline
Go to Solution.
May be this:
LOAD * Inline
LOAD Count(City_Name) as RowCount
CITY_NUM as City_Num
DROP Table TempCityMap;
You could also add the count into a variable as follows:
LET TableCount = NoOfRows('TempCityMap');
--Update This would need to be used on the TempCityMap table as in Sunny's example.
I just tried it with a sample app, doesn't seem to be working with Mapping LOAD.
Naresh, logfile does seem to have the row count information for Mapping Load
I just copied your TempCityMap and just realized it wasn't a mapping load.
Thought I was missing something about the question.
In full disclosure I had no idea if NoOfRow('TableName') would work or not, but would have been glad if it did
Somehow, I missed it.