difference between LOAD and SELECT

[Fuel666]

loading of this script is correct:

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=PROTEX;Data Source=XXX.XXX.XXX.XXX/XXXXX;Extended Properties=""] (XPassword is dbcfCYJOPDdKGcFI);

Tarif:

select taffornitore ,tafarticolo ,taflavorazione,
from ARKTAF
where ditta = '004' AND tafcosto > 0 OR ditta = '004' AND TAFFORFE = 'F'

group by taffornitore ,tafarticolo ,taflavorazione,

ORDER BY TAFARTICOLO

store [tarif] into ST_tarif_DATA.qvd;

instead this gives an error on the group by clause?

Tariff2:

LOAD
TAFARTICOLO,
TAFCOLORE,
TAFLAVORAZIONE,

FROM
[C:\QLIK\ST_tarif_DATA.qvd]
(qvd)

Group By

TAFARTICOLO,
TAFCOLORE,
TAFLAVORAZIONE,
;

Thank you

Best

[anat]

we should have aggregate function (sum,count,avg....) while using group by .

[Fuel666]

Ok,

thank you