topic Re: Message "Garbage after statement". in QlikView

Message "Garbage after statement".

wgonzalez — Thu, 28 Jun 2012 20:54:42 GMT

I'm loading a table from QVD and added the sorting specifications, but I'm getting the error message "Garbage after statement".

Could someone explain? Please see the script below. Thanks.

AttTrans:

LOAD TransType,

DTPunchDate,

AttHours,

EmpID,

BusinessUnit,

DeptNo,

DeptName,

WorkCenter,

PayGroup,

AbsenceYN,

ParentTrans,

AttendanceRevision,

TardinessRevision,

AttCategory

FROM

C:\QlikViewDocuments\Transf\Attendance\AttTrans.qvd

(qvd)

Order by DTPunchDate asc;

Re: Message "Garbage after statement".

erichshiino — Thu, 28 Jun 2012 21:01:03 GMT

Hi,

I reproduced your error and it is very strange. I'd say it is a bug.

As a workaround, if you really need your order by, you can load your table then use a load resident to order it.

It will be like this:

AttTrans:

LOAD TransType,

DTPunchDate,

AttHours,

EmpID,

BusinessUnit,

DeptNo,

DeptName,

WorkCenter,

PayGroup,

AbsenceYN,

ParentTrans,

AttendanceRevision,

TardinessRevision,

AttCategory

FROM

C:\QlikViewDocuments\Transf\Attendance\AttTrans.qvd

(qvd);

noconcatenate

temp:

Load * resident AttTrans

Order by DTPunchDate asc;

drop table AttTrans;

rename table temp to AttTrans;

Hope it helps,

Erich

Re: Message "Garbage after statement".

wgonzalez — Thu, 28 Jun 2012 22:19:10 GMT

Nice solution, thanks!

Re: Message "Garbage after statement".

wgonzalez — Thu, 28 Jun 2012 22:19:27 GMT

Nice solution, thanks!

Re: Message "Garbage after statement".

raajeshn — Tue, 07 Oct 2014 03:28:51 GMT

Hi,

Nice Solution, Thanks.

But am surprised, this is still an issue in QlikView 11.2 as well. Can somebody from Qlik have a dig at this please? Thanks.

Thanks & Regards,

Raajesh N

Re: Message "Garbage after statement".

lawrenceiow — Wed, 14 Mar 2018 10:50:32 GMT

It says in the Help screen (and therefore, I would assume, the user guide) for the LOAD command, "order by is a clause used for sorting the records of a resident table before they are processed by the load statement" I would suggest that Order By is working as intended.