topic Re: xls to qvd file error in QlikView

xls to qvd file error

Anonymous — Fri, 18 Sep 2015 08:40:03 GMT

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])

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 08:42:57 GMT

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?

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 08:45:19 GMT

this is the end bit:-

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

STORE Targets into [TeamConsultantTargets.qvd];

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 08:48:55 GMT

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?

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 08:51:16 GMT

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$);

Re: xls to qvd file error

PrashantSangle — Fri, 18 Sep 2015 08:52:30 GMT

Hi,

You need ; after [Targets])

Try it .

or post your complete script.

Regards

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 08:53:56 GMT

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:

STORE Targets into [TeamConsultantTargets.qvd]

Re: xls to qvd file error

qlikviewwizard — Fri, 18 Sep 2015 08:57:08 GMT

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.

Re: xls to qvd file error

qlikviewwizard — Fri, 18 Sep 2015 08:58:32 GMT

Hi,

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

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 09:00:23 GMT

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];

Re: xls to qvd file error

deepakqlikview_123 — Fri, 18 Sep 2015 09:01:29 GMT

please post your sample data

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 09:02:33 GMT

your Excel table is a normal table with the specified fields?

does your Excel file Looks like

Team Team_id role id Consultant [1/07/2015] [1{08{2015)....

TA 123 Manag 99 this def 100 200

then the Definition to

FROM

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

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

you may have clicked on "XML" definition

Re: xls to qvd file error

qlikviewwizard — Fri, 18 Sep 2015 09:05:59 GMT

Hi,

That is not complete script. There is no table name.....

Please use the script like this.

We should mention .qvd in store syntax.

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] (qvd);

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 09:08:30 GMT

i still get the error 😞 using your amended script.

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 09:10:12 GMT

do you see the table "Targets" in your datamodel (Strg+T)?

I believe you donot see the table!

Re: xls to qvd file error

qlikviewwizard — Fri, 18 Sep 2015 09:10:40 GMT

Hi, Do not worry.

1) Can you attach the Excel sample file...

2) Your Excel folder path

Re: xls to qvd file error

qlikviewwizard — Fri, 18 Sep 2015 09:12:07 GMT

For example:

1) TeamConsultantTargets.xlsx

2) C:\Users\laura\Downloads\Sourcefolder

Re: xls to qvd file error

Anonymous — Fri, 18 Sep 2015 09:15:44 GMT

i cant seem to see the attachment function to load my file?

Re: xls to qvd file error

qlikviewwizard — Fri, 18 Sep 2015 09:19:22 GMT

‌ I didn't get you.

DId you try my script or advise?!

Re: xls to qvd file error

PrashantSangle — Fri, 18 Sep 2015 09:22:08 GMT

Hi,

Use Advance Editior.

Regards