Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Radim
		
			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);)
 Vicky_Z
		
			Vicky_Z
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			Vicky_Z
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			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
		
			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
		
			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
		
			Vicky_Z
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I'll test the version of QSD and see if there is any major behavior change
 Vicky_Z
		
			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
		
			Vicky_Z
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			Vicky_Z
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			Radim
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Vicky, yes, it works for us too. Thanks a lot!
