Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
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:
CityMap:
Mapping LOAD * Inline
[
City_Name, CITY_NUM
PARIS, 6
LONDON, 4
LA, 347
SEATTLE, 11
CHICAGO, 12
];
ENDIF
May be this:
TempCityMap:
LOAD * Inline
[
City_Name, CITY_NUM
PARIS, 6
LONDON, 4
LA, 347
SEATTLE, 11
CHICAGO, 12
];
RowCount:
LOAD Count(City_Name) as RowCount
Resident TempCityMap;
CityMap:
Mapping
LOAD City_Name,
CITY_NUM as City_Num
Resident TempCityMap;
DROP Table TempCityMap;
May be this:
TempCityMap:
LOAD * Inline
[
City_Name, CITY_NUM
PARIS, 6
LONDON, 4
LA, 347
SEATTLE, 11
CHICAGO, 12
];
RowCount:
LOAD Count(City_Name) as RowCount
Resident TempCityMap;
CityMap:
Mapping
LOAD City_Name,
CITY_NUM as City_Num
Resident TempCityMap;
DROP Table TempCityMap;
Hi there,
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.
Thanks
Mark
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
Hi Sunny,
My mistake,
I just copied your TempCityMap and just realized it wasn't a mapping load.
Thought I was missing something about the question.
Mark
No problem.
In full disclosure I had no idea if NoOfRow('TableName') would work or not, but would have been glad if it did
Thanks Sunny.
Somehow, I missed it.
=count(City_Name)