difference between LOAD and SELECT

Fuel666 — Mon, 17 Jan 2022 21:57:08 GMT

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

Re: difference between LOAD and SELECT

anat — Tue, 18 Jan 2022 04:35:21 GMT

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

Re: difference between LOAD and SELECT

Fuel666 — Tue, 18 Jan 2022 08:14:51 GMT

Ok,

thank you

topic difference between LOAD and SELECT in QlikView

difference between LOAD and SELECT

Re: difference between LOAD and SELECT

Re: difference between LOAD and SELECT