topic Re: CSV file loaded correct in Qlik Sense Desktop, incorrect in Qlik Sense Business in App Development

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

Radim — Fri, 23 Jun 2023 14:28:54 GMT

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

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

Radim — Fri, 23 Jun 2023 14:49:56 GMT

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

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

Vicky_Z — Mon, 26 Jun 2023 08:34:21 GMT

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

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

Radim — Mon, 26 Jun 2023 10:15:10 GMT

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

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

Vicky_Z — Wed, 28 Jun 2023 00:59:49 GMT

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

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

Vicky_Z — Fri, 30 Jun 2023 05:37:00 GMT

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

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

Vicky_Z — Mon, 03 Jul 2023 07:00:15 GMT

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.

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

Vicky_Z — Tue, 11 Jul 2023 05:41:50 GMT

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?

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

Radim — Tue, 11 Jul 2023 05:40:55 GMT

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