Load error

[#1]

Hi All,

I am getting a load error with this script, can someone assist. Error says script is missing a from???

[2015 Dates]:

LOAD Distinct

     dated

     FROM

[2015 sales ytd.xlsx]

(ooxml, embedded labels, table is [2015]);

2015:

Load *,

RowNo() as [Sale Day]

Resident[2015 Dates]

Order by dated desc

;

DROP Table [2015 Dates];

Thank you

[marcus_malinow · Accepted solution]

2015:

Load *,

RowNo() as [Sale Day]

Resident [2015 Dates]

Order by dated desc

You just need to add a space after 'Resident'

[#3]

Eish, thank you!!!

[marcus_malinow]

No probs, happy to help.

Thanks for marking my answer correct.