topic Re: Resident load statement in QlikView

Resident load statement

Wed, 22 Jan 2014 15:56:19 GMT

Hi,

I'm trying to do the below but keep getting invalid syntax errors, I'm sure this is simple for someone in the know.

Could someone check this over for me? I'm gonna go crazy!

counties_temp:

SQL

select CNTY_NAM as unitaryArea

, points

from QlikMaps.dbo.counties2;

counties:

select unitaryArea, points

from counties_temp;

load unitaryArea,

concat(points,'<br>') as points

Resident counties_temp;

drop table counties_temp;

Re: Resident load statement

maxgro — Wed, 22 Jan 2014 16:00:55 GMT

counties_temp:

SQL

select CNTY_NAM as unitaryArea

, points

from QlikMaps.dbo.counties2;

counties:

noconcatenate

load unitaryArea,

concat(points,'<br>') as points

Resident counties_temp

group by unitaryArea;

drop table counties_temp;

Re: Resident load statement

Wed, 22 Jan 2014 16:01:42 GMT

Replace FROM with RESIDENT here:

counties:

select unitaryArea, points

from counties_temp;

Re: Resident load statement

Wed, 22 Jan 2014 16:07:45 GMT

Many thanks for your quick help.

Hope you have a nice day!