Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
nicoloantonietti
Contributor II
Contributor II

Load a large csv file

Platform: Qlik Cloud

Attached is the file vendite.csv

Labels (1)
2 Solutions

Accepted Solutions
Albert_Candelario

Hello @nicoloantonietti,

I have checked further and the issue is related to a known issue, QB-18874, for your reference.

The fix is already in progress, so should be delivered into the incoming weeks into our Qlik Cloud, so you can use the msq quoting again like below:


(txt, codepage is 28591, embedded labels, delimiter is ';', msq)

 

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer

View solution in original post

nicoloantonietti
Contributor II
Contributor II
Author

I'm assuming the fix was ported to production as the loading is working again.

Thanks for your assistance.

 

Best

View solution in original post

15 Replies
Albert_Candelario

Hello @nicoloantonietti ,

Thanks for posting.

What is the challenge here? What issue do you have loading the csv file?

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
nicoloantonietti
Contributor II
Contributor II
Author

I thought I added the file in the attachment of the post where I explained the issue. It seems not and I apologize.

The issue is with the loading of the file in QlikSense Cloud. It worked for years and, all of a sudden, it is not possible to load it unless it has no more than 151500.

I was asked to attach the file as an example and that's why I did that.

ID-APP: ab182acd-1456-4a57-81a7-797be113ac99

Albert_Candelario

Hello @nicoloantonietti,

Do you have a sample csv that we could use to try to reproduce your behavior?

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
fmarvnnt
Partner - Creator III
Partner - Creator III

I guys I guess this could be a support case,  do U?

 

Regards,

 

FMa

 

Albert_Candelario

Hello all,

If you could provide a sample csv, I would be happy to have a look with no need of a case. If afterwards a case would be needed we would share the same.

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
nicoloantonietti
Contributor II
Contributor II
Author

File attached.

Thank you.

Albert_Candelario

Hello @nicoloantonietti ,

The error we are hitting is:

Data source line limit exceeded. Max line length is 1048576 bytes.

And thanks for the file. Let's dig a bit on what could be the culprit here as seems some limits are getting reached.

Cheers,

Albert

 

 

Please, remember to mark the thread as solved once getting the correct answer
Albert_Candelario

Hello @nicoloantonietti ,

If using the below setting it has loaded for me.

(txt, codepage is 28592, embedded labels, delimiter is ';', no quotes, no eof);

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
Albert_Candelario

Hello @nicoloantonietti,

I have checked further and the issue is related to a known issue, QB-18874, for your reference.

The fix is already in progress, so should be delivered into the incoming weeks into our Qlik Cloud, so you can use the msq quoting again like below:


(txt, codepage is 28591, embedded labels, delimiter is ';', msq)

 

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer