summerise table

[#1]

I have this table

and in the first column is the Key, which repeats 3times (because of 3 concatenated tables). In the other columns there is just one value for the keys.

Now I want to summerise this table to 1 row, with all the values in the columns

My script looks like this

Table:

load Key,

     Column1,

     Column2 

resident Temp;

What do I have to add to Summerise the table?  I tried group by but I get error messages

Thanks a lot in advanced

Thomas

[#2 · Accepted solution]

Table:

load Key,

     sum(Column1),

     sum(Column2) 

resident Table_temp

GRUP BY  Key;

(DROP TABLE Table_temp// if you don't need anymore)

[#3]

Thanks a lot, this is perfectly working