Data Load Failed - How do I fix?

[#1]

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!

[Clever_Anjos]

Would you mind sharing your script?

[Clever_Anjos]

I could load your excel file using both Qlikview and Sense

[#4]

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

[MarcoWedel]

Hi,

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

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

[MarcoWedel]

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

Can you please post the rest as well?

thanks

regards

Marco

[Clever_Anjos]

Please post all sections from your script

[#8]

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...

[MarcoWedel]

Good to hear it works now.

regarding the closing, maybe this helps:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco