xls to qvd file error

[Anonymous]

Hi,

I'm trying load the following into a qvd file.  but keep getting errors.  any help appreciated.

Script line error:
Let varFileName= 'C:\QlikView Documents\ABLAC Business Performance\'&  'TeamConsultantTargets.qvd'

Targets:

LOAD Team,
     team_id,
     role,
     id,
     Consultant,
     [1/07/2015],
     [1/08/2015],
     [1/09/2015],
     [1/10/2015],
     [1/11/2015],
     [1/12/2015],
     [1/01/2016],
     [1/02/2016],
     [1/03/2016],
     [1/04/2016],
     [1/05/2016],
     [1/06/2016],
   
FROM
[..\Excel Source Targets\TeamConsultantTargets.xlsx]
(ooxml, embedded labels, table is Targets[Targets])

[Anonymous]

the last field before from may not ended by comma (or does more fields follow?)

    [1/06/2016]

FROM

[..\Excel Source Targets\TeamConsultantTargets.xlsx]

(ooxml, embedded labels, table is Targets[Targets])

you want to load the result into qvd?

but I donot see a store Definition?

[Anonymous]

this is the end bit:-

FROM
[..\Excel Source Targets\TeamConsultantTargets.xlsx]
(ooxml, embedded labels, table is Targets[Targets])

STORE Targets into [TeamConsultantTargets.qvd];

[Anonymous]

Looks good

so where is the Problem?

The table Targets is created and filled with data? and store does not work?

Or the table is not created? Does your Statement Ends with field {1/06/2016]?

Did you use Table Viewer to insert the Excel file or did you enter the Definition manually?

[Anonymous]

I see that you try to load an XML Excel:

[..\Excel Source Targets\TeamConsultantTargets.xlsx]
(ooxml, embedded labels, table is Targets[Targets])

following example from another Excel file

[..\Database\Films Database.xls]
(biff, embedded labels, table is Films$);

[PrashantSangle]

Hi,

You need ; after [Targets])

Try it .

or post your complete script.

Regards

[Anonymous]

i used the "tables file" to load it.  I'm still getting error = Script line error:

Let varFileName= 'C:\QlikView Documents\ABLAC Business Performance\'&  'TeamConsultantTargets.qvd'

Targets:

LOAD Team,
     team_id,
     role,
     id,
     Consultant,
     [1/07/2015],
     [1/08/2015],
     [1/09/2015],
     [1/10/2015],
     [1/11/2015],
     [1/12/2015],
     [1/01/2016],
     [1/02/2016],
     [1/03/2016],
     [1/04/2016],
     [1/05/2016],
     [1/06/2016],
   
FROM
[..\Excel Source Targets\TeamConsultantTargets.xlsx]
(ooxml, embedded labels, table is Targets[Targets])

STORE Targets into [TeamConsultantTargets.qvd]

[qlikviewwizard]

Hi,

Instead of using Relative path, use the full path.

For example:

Targets:

LOAD Team,

    team_id,

    role,

    id,

    Consultant,

    [1/07/2015],

    [1/08/2015],

    [1/09/2015],

    [1/10/2015],

    [1/11/2015],

    [1/12/2015],

    [1/01/2016],

    [1/02/2016],

    [1/03/2016],

    [1/04/2016],

    [1/05/2016],

    [1/06/2016]  

FROM

(ooxml, embedded labels, table is Targets[Targets])

store Targets into C:\Qlikview Data\QVD Targets\TeamConsultantTargets.qvd (qvd);

Hope this will help you.

[qlikviewwizard]

Hi,

Post your complete script or use the above script as an example.

[Anonymous]

still get the error: full script:-

LOAD Team,
team_id,
role,
id,
Consultant,
[1/07/2015],
[1/08/2015],
[1/09/2015],
[1/10/2015],
[1/11/2015],
[1/12/2015],
[1/01/2016],
[1/02/2016],
[1/03/2016],
[1/04/2016],
[1/05/2016],
[1/06/2016]

FROM
[..\Excel Source Targets\TeamConsultantTargets.xlsx]
(ooxml, embedded labels, table is Targets[Targets]);

STORE Targets into [TeamConsultantTargets.qvd];