I'm trying to load in an excel spreadsheet. Its just 1 sheet, and I've tried to load it a few ways, but always comes back with an syntax error 'missing/misplaced FROM:'
I've listed the error below. I would just like to point out, I'm only trying to load the ONE sheet, so why is the script trying to load 2?!
This is what the error returns:
Syntax error, missing/misplaced FROM:
LOAD Company,
Ledger,
AC1,
Region,
AC2,
Controller,
[Calc AC3],
[SC/NAM],
AC4,
[Grp A/C / Cycle],
[Legacy Account],
Customer,
Name,
Status,
[Account Balance],
[Total Exc Unallocated Cash],
[<90days],
[>90days],
[>60days],
[Not Yet Due],
[0-30],
[31-60],
[61-90],
[91-120],
[121-150],
[151-180],
[181-365],
[365+],
Cash,
[Group No],
[Payment Method],
[Invoice Frequency],
[Advance/Arrears],
[Payment Terms],
[Credit Limit],
[Company Registration Number],
[Experian Credit Limit]]],
[Current Risk Category],
[Previous Delphi Score],
[Delphi Score],
[Customer On CAS],
[Account On CAS],
[Customer Has Portfolio],
[Contracts Exist],
[Jobs Exist],
[Customer Portfolio Value],
[Account Has Portfolio],
[Job Exists],
[Account Portfolio Value],
[Contracts Exists]
FROM
(ooxml, embedded labels, table is Sheet1)
LOAD Company,
Ledger,
AC1,
Region,
AC2,
Controller,
[Calc AC3],
[SC/NAM],
AC4,
[Grp A/C / Cycle],
[Legacy Account],
Customer,
Name,
Status,
[Account Balance],
[Total Exc Unallocated Cash],
[<90days],
[>90days],
[>60days],
[Not Yet Due],
[0-30],
[31-60],
[61-90],
[91-120],
[121-150],
[151-180],
[181-365],
[365+],
Cash,
[Group No],
[Payment Method],
[Invoice Frequency],
[Advance/Arrears],
[Payment Terms],
[Credit Limit],
[Company Registration Number],
[Experian Credit Limit]]],
[Current Risk Category],
[Previous Delphi Score],
[Delphi Score],
[Customer On CAS],
[Account On CAS],
[Customer Has Portfolio],
[Contracts Exist],
[Jobs Exist],
[Customer Portfolio Value],
[Account Has Portfolio],
[Job Exists],
[Account Portfolio Value],
[Contracts Exists]
FROM
(ooxml, embedded labels, table is Sheet1)
This is the script:
LOAD Company,
Ledger,
AC1,
Region,
AC2,
Controller,
[Calc AC3],
[SC/NAM],
AC4,
[Grp A/C / Cycle],
[Legacy Account],
Customer,
Name,
Status,
[Account Balance],
[Total Exc Unallocated Cash],
[<90days],
[>90days],
[>60days],
[Not Yet Due],
[0-30],
[31-60],
[61-90],
[91-120],
[121-150],
[151-180],
[181-365],
[365+],
Cash,
[Group No],
[Payment Method],
[Invoice Frequency],
[Advance/Arrears],
[Payment Terms],
[Credit Limit],
[Company Registration Number],
[Experian Credit Limit]]],
[Current Risk Category],
[Previous Delphi Score],
[Delphi Score],
[Customer On CAS],
[Account On CAS],
[Customer Has Portfolio],
[Contracts Exist],
[Jobs Exist],
[Customer Portfolio Value],
[Account Has Portfolio],
[Job Exists],
[Account Portfolio Value],
[Contracts Exists]
FROM
(ooxml, embedded labels, table is Sheet1);
I've loaded a similar script with no problems.
I've tried saving it as a CSV as well, with the same problem.
