Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Data Load Failed - How do I fix?

Hello,

I am very new to the Qlik platform and attempting to learn it for better job prospects. I tried loading a simple data set from excel and I keep getting this error below.

Data Load Failed

Elapsed Time 00:00:01

Data was not loaded because of errors in the script. Please correct the script in the data load editor and reload data.

Attached is the excel file I'm trying to load. Thanks for the help!

8 Replies
Employee
Employee

Re: Data Load Failed - How do I fix?

Would you mind sharing your script?

Employee
Employee

Re: Data Load Failed - How do I fix?

I could load your excel file using both Qlikview and Sense

Not applicable

Re: Data Load Failed - How do I fix?

Is this what you're looking for?

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 FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET CreateSearchIndexOnReload=1;

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

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

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

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Re: Data Load Failed - How do I fix?

Hi,

here is the script the import wizard creates. It loads your sample file without errors:

QlikCommunity_Thread_248709_Pic2.JPG

QlikCommunity_Thread_248709_Pic1.JPG

LOAD Rk,

    Player,

    Team,

    Pos,

    Comp,

    Att,

    Pct,

    [Attepts per game],

    Yds,

    Avg,

    [Yards per game],

    TD,

    Int,

    [1st],

    [First down percentage],

    Lng,

    [20 plus yards],

    [40 plus yards],

    Sacks,

    Rating

FROM

[https://community.qlik.com/servlet/JiveServlet/download/1206344-264067/Top%2050%20QBs.xlsx]

(ooxml, embedded labels, table is Sheet1);

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

hope this helps

regards

Marco

Re: Data Load Failed - How do I fix?

this seems to be only the main section of your Sense load script.

Can you please post the rest as well?

thanks

regards

Marco

Employee
Employee

Re: Data Load Failed - How do I fix?

Please post all sections from your script

Not applicable

Re: Data Load Failed - How do I fix?

I tried loading it again and changed nothing and it worked! I don't know why

it wouldn't the first few times and I got that error message but I'll go ahead and close. Thanks...

Re: Data Load Failed - How do I fix?

Good to hear it works now.

regarding the closing, maybe this helps:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco