Resident load statement

[#1]

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;

[maxgro · Accepted solution]

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;

[#3]

Replace FROM with RESIDENT here:

counties:

select unitaryArea, points

from counties_temp;

[#4]

Many thanks for your quick help.

Hope you have a nice day!