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!
Is this what you're looking for?
SET TimeFormat='h:mm:ss TT';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
here is the script the import wizard creates. It loads your sample file without errors:
[Attepts per game],
[Yards per game],
[First down percentage],
[20 plus yards],
[40 plus yards],
(ooxml, embedded labels, table is Sheet1);
please close your thread if your question is answered:
hope this helps
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...