topic Re: Row count in mapping table in QlikView

Row count in mapping table

vchuprina — Thu, 14 Jan 2016 11:03:33 GMT

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

Re: Row count in mapping table

sunny_talwar — Thu, 14 Jan 2016 11:06:32 GMT

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;

Re: Row count in mapping table

markodonovan — Thu, 14 Jan 2016 11:19:21 GMT

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

http://techstuffybooks.com

Re: Row count in mapping table

sunny_talwar — Thu, 14 Jan 2016 11:26:03 GMT

I just tried it with a sample app, doesn't seem to be working with Mapping LOAD.

Re: Row count in mapping table

sunny_talwar — Thu, 14 Jan 2016 11:30:57 GMT

Naresh‌, logfile does seem to have the row count information for Mapping Load

Re: Row count in mapping table

markodonovan — Thu, 14 Jan 2016 11:35:10 GMT

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

Re: Row count in mapping table

sunny_talwar — Thu, 14 Jan 2016 11:38:25 GMT

No problem.

In full disclosure I had no idea if NoOfRow('TableName') would work or not, but would have been glad if it did

Re: Row count in mapping table

NareshGuntur — Thu, 14 Jan 2016 11:40:41 GMT

Thanks Sunny.

Somehow, I missed it.

Re: Row count in mapping table

Anonymous — Thu, 14 Jan 2016 12:05:06 GMT

=count(City_Name)