topic Re: Data Load Failed - How do I fix? in QlikView

Data Load Failed - How do I fix?

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Data Load Failed - How do I fix?

Clever_Anjos — Sat, 04 Feb 2017 00:17:13 GMT

Would you mind sharing your script?

Re: Data Load Failed - How do I fix?

Clever_Anjos — Sat, 04 Feb 2017 00:19:07 GMT

I could load your excel file using both Qlikview and Sense

Re: Data Load Failed - How do I fix?

Sat, 04 Feb 2017 16:53:41 GMT

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?

MarcoWedel — Sat, 04 Feb 2017 21:16:58 GMT

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

Re: Data Load Failed - How do I fix?

MarcoWedel — Sun, 05 Feb 2017 17:31:20 GMT

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

Can you please post the rest as well?

thanks

regards

Marco

Re: Data Load Failed - How do I fix?

Clever_Anjos — Mon, 06 Feb 2017 19:18:26 GMT

Please post all sections from your script

Re: Data Load Failed - How do I fix?

Mon, 06 Feb 2017 20:01:03 GMT

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?

MarcoWedel — Mon, 06 Feb 2017 21:04:19 GMT

Good to hear it works now.

regarding the closing, maybe this helps:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco