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]

sorry.  i meant that i cant load the file as I don't have an attachment link

[Anonymous]

excel looks like this :

Team	team_id	role	id	Consultant	1/07/2015	1/08/2015	1/09/2015	1/10/2015
BDL	1	field_officer	11	Peter Mulster	71	71	71	71
Western Team	7	field_officer	13	Melissa Loonar	38	38	38	37
BDL	1	field_officer	47	Bianca Castagna	57	57	57	57
Sydney South Team	5	field_officer	61	Barbara Mya	8	8	8	8

[qlikviewwizard]

i am very sorry for your issue. I didn't understand in giving details.

[qlikviewwizard]

Without giving ‌complete details we can not resolve your issue. Hope you understood the situation.

[Anonymous]

how can i load the file?

[PrashantSangle]

Hi,

Click on Reply You see editor and at top right corner you see Use Advanced editor.

Click on it, there you will able to attached file.

Regards.

[qlikviewwizard]

a‌ttach the excel file

[Anonymous]

perfect:

what I tell you now the third time:

YOU ARE LOADING AS XML definitions. That cannot work!!! YOU DONOT SEE THE TABLE TARGETS!

FROM

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

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

[qlikviewwizard]

‌did you able to resolve your issue?