CSV file loaded correct in Qlik Sense Desktop, incorrect in Qlik Sense Business

[Radim]

Hi!

I have a problem loading csv file into qlik sense business. The csv file contains strings including doublequotes, linebreaks etc. I believe that the csv is correctly quoted. I do not understand, how is it possible that I can read it correctly into Qlik Sense Desktop but cannot load in into cloud business. I take the same csv, load it into qlik sense business datafiles and than load it with the same script as i use in desktop. CSV and results after loading to QSD and QSB attached.

Any help is appreciated.

Thanks!

----------------------

load

*

FROM [lib://DataFiles/testCSV.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);)

[Radim]

It seems that the document reader ("Preview file") in this forum is able to read it correctly too! But Qlik Sense Business is not?

[Vicky_Z]

@Radim  I tried a few quoting option as well as "no quote" in loading script, but got the same behavior. I also tested in Qlik Sense Desktop and got the same result. Could you please let me know which version of QSD you tested so I can check if there is any change/difference between them?

Currently the workaround could be clean the source file before loading or re-save it as xlsx file.

[Radim]

@Vicky_Z I am using qliksensedesktop: 14.54.2

We have more csvs with this problem, exceeding milions of rows, so saving as xlsx file will not work. I have a workaround using the desktop version or python scripts but it would save me a lot of time being able to load it directly into QSB.

[Vicky_Z]

I'll test the version of QSD and see if there is any major behavior change

[Vicky_Z]

I tested in QSD May 22 and it worked there. I feel there is some behavior change in recent versions. I may request a defect to R&D for some more opinion. I will keep you update in the ticket

[Vicky_Z · Accepted solution]

This is confirmed as a degrade in recent versions and the fix will be included in the new engine. But I recently checked on my tenant and the fix has not been released yet. 

[Vicky_Z · Accepted solution]

Hi @Radim  Just checked my QCB. It appears the fix has been released. The double quotes in the sample csv file can be correctly recognised. Could you please check in your tenant? 

[Radim]

Hi Vicky, yes, it works for us too. Thanks a lot!