topic Order BY and "Garbage after statement..." in QlikView

Order BY and "Garbage after statement..."

alexis — Fri, 12 Oct 2012 08:31:16 GMT

Hi,

This produces the dreaded "Garbage after statement...."

Prices:

LOAD OrderID,

OpenClose,

Ask,

Bid

FROM

TestPrices.xls

(biff, embedded labels, table is Prices$)

ORDER BY OrderID;

and this works fine:

temp:

LOAD OrderID,

OpenClose,

Ask,

Bid

FROM

TestPrices.xls

(biff, embedded labels, table is Prices$)

;

NoConcatenate

Prices:

LOAD * Resident temp

Order by OrderID;

drop Table temp;

Any ideas?

Fri, 12 Oct 2012 12:14:32 GMT

Hi Alexis,

an Order By-Clause is only valid for resident tables.

Unfortunaly there comes no (syntax) error from the editor when using it in the wrong way.

alexis — Fri, 12 Oct 2012 12:24:58 GMT

Thank you for responding to my question Roland - I was not aware of that.

Alexis

maksim_senin — Thu, 08 Nov 2012 04:02:14 GMT

That would be a good thing to show more informative message in this case.