Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working on handling error in Qlik Sense script and wanted to know if any one has encountered "File has wrong format" error and when exactly we receive this error?
Any help is much appreciated
thanks in advance
You can get that error when the file format you specified doesn't match the real format. For example you specify loading from an xls file, but it's actually an xlsx file. Or you specify a csv format (txt with a comma as delimiter), but the file is zipped.
@sunny_talwar , @Gysbert_Wassenaar , @jagan , @tresesco
Any input on this would be really helpful
Hello @punitpoplil, would you have the script log? We could check if we can see further information on there. Thank you!
I am not getting the mentioned error in my script.
I wanted to know when we usually get this error? as am working on handling all the errors in the script and want to handle this one as well upfront in my script.
Can you please let me now when we get this error? its when reading the data from file in some other format?
You can get that error when the file format you specified doesn't match the real format. For example you specify loading from an xls file, but it's actually an xlsx file. Or you specify a csv format (txt with a comma as delimiter), but the file is zipped.
Hello @punitpopli, sorry, I understood you had this error when you executed your script. I can confirm what @Gysbert_Wassenaar said. Thanks a lot!
Hi @Gysbert_Wassenaar , @Patricia_Silva and @punitpopli Even i am getting this type of error i have tried to debug the script below is the error i am getting.
ScriptErrorCount 1
ScriptErrorDetails QVX_UNKNOWN_ERROR:
ScriptErrorList File Has Wrong Format
ScriptError File Has Wrong Format
LongDayNames "Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday"
DayNames "Mon;Tue;Wed;Thu;Fri;Sat;Sun"
LongMonthNames "January;February;March;April;May;June;July;August;September;October;November;December"
MonthNames "Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec"
CollationLocale "en-US"
FirstMonthOfYear 1
ReferenceDay 0
BrokenWeeks 1
FirstWeekDay 6
TimestampFormat "M/D/YYYY h:mm:ss[.fff] TT"
DateFormat "M/D/YYYY"
TimeFormat "h:mm:ss TT"
MoneyFormat "$#,##0.00;-$#,##0.00"
MoneyDecimalSep "."
MoneyThousandSep ","
DecimalSep "."
ThousandSep ","
OpenUrlTimeout 86400
StripComments 1
ErrorMode 1
WinRoot "C:"
WinPath "C:\Windows"
QvWorkRoot "D:"
QvWorkPath "D:\DEV\DATA\GenerationQVDQlikView\SALES\Stock"
QvRoot "C:"
QvPath "C:\Program Files\QlikView"
CD "C:"
Can you please help me with this ?? Thank you in advance.