topic Garbage after statement error at script level in QlikView

Garbage after statement error at script level

naziralala — Fri, 16 Oct 2015 02:56:56 GMT

Hello All,

I am getting this error for the foll script:

[H1]:

Load Distinct] [VCode],

[ACode

From [PD.qvd](qvd)

where group='5'

Order by [ACode],[VCode] desc;

Can anybody point out the error?

Thanks in advance.

Nazira

Re: Garbage after statement error at script level

lironbaram — Fri, 16 Oct 2015 03:18:44 GMT

you can't use order by when you load directly from qvd

you can only use it when you load resident tables

so you'll need to change the script

[H1Temp]:

Load Distinct] [VCode],

[ACode

From [PD.qvd](qvd)

where group='5';

[H1]:

noconcatenate load *

resident H1Temp

Order by [ACode],[VCode] desc;

drop table H1Temp;

Re: Garbage after statement error at script level

tamilarasu — Fri, 16 Oct 2015 03:52:41 GMT

Try this. You wronlgly entered square bracket after distinct and there is missing bracket after ACode field. As said by Liron, you can't use Order By clause for qvd file. You can use only for resident table .

Temp:
Load Distinct  [VCode]
              ,[ACode]
From [PD.qvd] (qvd)
Where Group='5';
NoConcatenate
H1:
Load *
Resident Temp
Order BY [ACode],[VCode] Desc;


DROP Table Temp;

Re: Garbage after statement error at script level

Kushal_Chawda — Fri, 16 Oct 2015 04:00:41 GMT

You can perform the Order by Operation on the data which is loaded into the memory. So order by only works on resident load

[H1]:

Load Distinct [VCode],

[ACode

From [PD.qvd](qvd)

where group='5';

H2:

noconcatenate

load *

resident H1

Order by [ACode],[VCode] desc;

drop table H1;

Re: Garbage after statement error at script level

Anonymous — Fri, 16 Oct 2015 06:03:09 GMT

Hi Nazirala,

According to Help:

"ORDER BY is a clause used for sorting the records of a Resident table before they are processed by the load statement."

The ORDER BY Statement orders data ASC/DESC,if order by is used for other than Resident load it might not order properly as it will be working as data is loaded.to work properly and order correctly,the whole data should be in memory.

[H1]:

Load Distinct [VCode],

[ACode]

From [PD.qvd](qvd)

where group='5';

[H2]:

Noconcatenate

Load Distinct [VCode],

[ACode]

Resident H1

Order by [ACode],[VCode] desc;

Drop Table H1;