Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Trouble with creating new from xls - execution of script failed

Ok - I have been trying lots of options - reduced the data set, filtered out and replaced characters that might create issues.  Can someone help - or point me to some help materials on creation issues from a xls data set?  Size limitations - rows, characters, columns - character issues - like - do I have to remove all "&".  I have tried these types of things and the create new still is failing with the same error. 

Please help - thanks!

7 Replies

Re: Trouble with creating new from xls - execution of script failed

Can you post xls?

Not applicable

Re: Trouble with creating new from xls - execution of script failed

Yes – but I have to mask some of it first.

Not applicable

Re: Trouble with creating new from xls - execution of script failed

I couldn’t see how to upload the xls – so here is the file – in a condensed and masked version.

Thanks, David

Not applicable

Re: Trouble with creating new from xls - execution of script failed

Here is the script that failed:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD ,

,

,

,

Type,

SLT,

,

,

,

,

FROM

(ooxml, embedded labels);

Re: Trouble with creating new from xls - execution of script failed

I had no problem .... se the attachment modified!

Not applicable

Re: Trouble with creating new from xls - execution of script failed

So - what did you have to change? And if not anything - what do you suggest I do to resolve?

Not applicable

Re: Trouble with creating new from xls - execution of script failed

Ok – I had someone look at this for me and the quickly figured it out – two columns with the same name – simple error – should have caught this.

Community Browser