Load a large csv file

[nicoloantonietti]

Platform: Qlik Cloud

Attached is the file vendite.csv

[Albert_Candelario]

Hello @nicoloantonietti ,

Thanks for posting.

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

Cheers,

Albert

[nicoloantonietti]

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

[fmarvnnt]

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

[nicoloantonietti]

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

[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

[Albert_Candelario · Accepted solution]

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