Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
dinicholls
Contributor 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

Re: Excel - Trying to Load Twice?!

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

Re: Excel - Trying to Load Twice?!

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

Partner
Partner

Re: Excel - Trying to Load Twice?!

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
Contributor II

Re: Excel - Trying to Load Twice?!

Durrr!!!

Couldn't see it for looking!!

Thanks!!

Di