3 Replies Latest reply: Oct 31, 2016 7:07 AM by Diane Nicholls RSS

    Excel - Trying to Load Twice?!

    Diane Nicholls

      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

      [S:\Management Information Team\02 WEEKLY REPORTS WORKINGS\IWS\IWS Dashboard\QlikView AC3 Generator - Wash\Mid Extracts\test.xlsx]

      (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

      [S:\Management Information Team\02 WEEKLY REPORTS WORKINGS\IWS\IWS Dashboard\QlikView AC3 Generator - Wash\Mid Extracts\test.xlsx]

      (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

      [S:\Management Information Team\02 WEEKLY REPORTS WORKINGS\IWS\IWS Dashboard\QlikView AC3 Generator - Wash\Mid Extracts\test.xlsx]

      (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