Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

Can you post xls?

Not applicable
Author

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

Not applicable
Author

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

Thanks, David

Not applicable
Author

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

alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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

Not applicable
Author

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.