Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Excel - Trying to Load Twice?!

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

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

3 Replies
avinashelite

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

stigchel
Partner - Master
Partner - Master

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

dinicholls
Creator II
Creator II
Author

Durrr!!!

Couldn't see it for looking!!

Thanks!!

Di