excel export merging all the data in single column

[nakuldev]

Hi,

I am facing issue while exporting data from pivot table to excel. It's just a straight forward export and not using any macros.

The export is working fine in local but while exporting from access point, all the columns are merged into one single column and column headers are also missing.   

Please find the attachment for reference.

Thanks

Nakul

[lorenzoconforti]

Looks like it's just exporting a csv file. How big is the table?

Have you tried converting in Excel using Text to Columns?

[Brett_Bleess]

It would be best if you can attach a QVW on this, so we can try things, you did not mention the version you are running, that would be helpful in this case too, as want to be sure there were no known issues etc.  Need the xx.xx.xxxxx number or xx.xx SRx.  There does seem to be an issue with opening the CSV file, as I believe the other poster was correct about that part of things, if there are fewer than 65k rows, it should export as xls or xlsx, but if more than that number of rows, it will change to CSV.  There were changes to the Export to Excel in 12.30 track if I recall correctly, we started using xlsx, so if your Desktop is 12.30 but your QVServer is still running older version, that could be part of the issue too...  Best I have for the moment.

Regards,
Brett

[nakuldev]

Hi,

There are multiple pivot tables, size ranges from 10 MB to more than 100
MB.
To do text to column in excel, I can’t suggest it to end users.

What could be the issue?

Thanks
Nakul

[lorenzoconforti]

How many rows is the table you are trying to export?

[nakuldev]

Hi Brett,

QV version which we are using is 12.30, both in local and server. Records are more than 400k and Yes, it is opening in csv. For few filters it is exporting correctly but for few it is not. In final we need to extract all the data, there it is going wrong.Data is confidential to attach. 

Users were able to export earlier but recent days it started failing.

Thanks

Nakul

[Brett_Bleess]

You did not mention full version, what SR of 12.30 are you running, as I did find a defect in the Initial Release (IR) of 12.30, so if you are on 12.30.20000, that is going to be a problem, would recommend running 12.30.20300 (SR3) if that is the case.  Best I have for you at the moment.

Regards,
Brett

[lorenzoconforti]

see if this helps:

https://community.qlik.com/t5/QlikView-Management/AccessPoint-Export-to-CSV-with-commas/td-p/1312064

[nakuldev]

Hi Brett,

I already gone through the above link and all the format is similar.

Regards

Nakul

[lorenzoconforti]

It appears other have had the same issue as you've had; a common solution has been to add UseIcuForLocaleInfo=0 into Setting.ini file:

https://support.qlik.com/articles/000064983

https://community.qlik.com/t5/QlikView-App-Development/November-2018-Release-Issue-with-Export-to-CS...