QlikView Personal creates a faulty script

[#1]

Hi!

I have my data in an Excel file, created from CSV values. The script that QlikView generates is faulty. How can I correct it?

Felaktig syntax, saknad/felplacerad FROM:

LOAD [Summation column],

     Id,

     Requester,

     [Requester id],

     [Requester external id],

     [Requester email],

     [Requester domain],

     Submitter,

     Assignee,

     Group,

     Subject,

     Tags,

     Status,

     Priority,

     Via,

     [Ticket type],

     [Created at],

     [Updated at],

     [Assigned at],

     Organization,

     [Due date],

     [Initially assigned at],

     [Solved at],

     [Resolution time],

     [Satisfaction Score],

     [Group stations],

     [Assignee stations],

     Reopens,

     Replies,

     [First reply time in minutes],

     [First reply time in minutes within business hours],

     [First resolution time in minutes],

     [First resolution time in minutes within business hours],

     [Full resolution time in minutes],

     [Full resolution time in minutes within business hours],

     [Agent wait time in minutes],

     [Agent wait time in minutes within business hours],

     [Requester wait time in minutes],

     [Requester wait time in minutes within business hours],

     [On hold time in minutes],

     [On hold time in minutes within business hours],

     [Type of Question

]],

     [Freefloat Product

]],

     [Version [txt]]],

     [Device manufacturer/model [txt]]]

FROM

(ooxml, embedded labels)

LOAD [Summation column],

     Id,

     Requester,

     [Requester id],

     [Requester external id],

     [Requester email],

     [Requester domain],

     Submitter,

     Assignee,

     Group,

     Subject,

     Tags,

     Status,

     Priority,

     Via,

     [Ticket type],

     [Created at],

     [Updated at],

     [Assigned at],

     Organization,

     [Due date],

     [Initially assigned at],

     [Solved at],

     [Resolution time],

     [Satisfaction Score],

     [Group stations],

     [Assignee stations],

     Reopens,

     Replies,

     [First reply time in minutes],

     [First reply time in minutes within business hours],

     [First resolution time in minutes],

     [First resolution time in minutes within business hours],

     [Full resolution time in minutes],

     [Full resolution time in minutes within business hours],

     [Agent wait time in minutes],

     [Agent wait time in minutes within business hours],

     [Requester wait time in minutes],

     [Requester wait time in minutes within business hours],

     [On hold time in minutes],

     [On hold time in minutes within business hours],

     [Type of Question

]],

     [Freefloat Product

]],

     [Version [txt]]],

     [Device manufacturer/model [txt]]]

FROM

(ooxml, embedded labels)

[hic]

If your field names contain [ or ] , then this can happen. You need to manually change the field references to use " " instead of [ ]. Example, change

     [Type of Question

]],

to

     "Type of Question

",

HIC

[#3]

That makes sense. Thanks for the tips.

But why does the wizard create a faulty script without warnings?