Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Specialist
Partner - Specialist

Order BY and "Garbage after statement..."

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?

1 Solution

Accepted Solutions
Not applicable

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. 

RR

View solution in original post

3 Replies
Not applicable

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. 

RR

alexis
Partner - Specialist
Partner - Specialist
Author

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

Alexis

maksim_senin
Partner - Creator III
Partner - Creator III

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