Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Any ideas?!
Thanks
Diane
Try to load the data from edit script >tables files and choose the file you want to load..
I have a doubt about the syntax of this field
[Experian Credit Limit]]],
Try to comment this and reload once
Try to load the data from edit script >tables files and choose the file you want to load..
I have a doubt about the syntax of this field
[Experian Credit Limit]]],
Try to comment this and reload once
Hi
If the field name in excel has [ and/or ] characters in it, use "" instead of [] in the load script
For example
Load
...
"[Experian Credit Limit]]",
...
From
Durrr!!!
Couldn't see it for looking!!
Thanks!!
Di