Excel - Trying to Load Twice?!

dinicholls — Fri, 28 Oct 2016 09:33:20 GMT

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

Re: Excel - Trying to Load Twice?!

avinashelite — Fri, 28 Oct 2016 14:09:22 GMT

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

Re: Excel - Trying to Load Twice?!

stigchel — Fri, 28 Oct 2016 14:43:47 GMT

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

Re: Excel - Trying to Load Twice?!

dinicholls — Mon, 31 Oct 2016 11:07:06 GMT

Durrr!!!

Couldn't see it for looking!!

Thanks!!

topic Excel - Trying to Load Twice?! in QlikView

Excel - Trying to Load Twice?!

Re: Excel - Trying to Load Twice?!

Re: Excel - Trying to Load Twice?!

Re: Excel - Trying to Load Twice?!