I am struggling with the following code, can anyone assist in letting me know where I am going wrong. Its the resident load bit that's not quite working. Also when doing an order by, can I use the aliases from the previous table?
LOAD [Submission Id],
[Fieldworker Name] as [Field staff],
Km as Reading,
(ooxml, embedded labels, table is [1 Rainfall Odometer])
WHERE(Year(Date) = '2014' And Mileage > '0' And Mileage < '10000');