topic Re: excel export merging all the data in single column in QlikView

excel export merging all the data in single column

nakuldev — Sat, 16 Nov 2024 01:36:33 GMT

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

Re: excel export merging all the data in single column

lorenzoconforti — Thu, 02 Jan 2020 11:27:01 GMT

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

Have you tried converting in Excel using Text to Columns?

Re: excel export merging all the data in single column

Brett_Bleess — Thu, 02 Jan 2020 15:28:53 GMT

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

Re: excel export merging all the data in single column

nakuldev — Thu, 02 Jan 2020 15:34:35 GMT

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

Re: excel export merging all the data in single column

lorenzoconforti — Thu, 02 Jan 2020 15:36:30 GMT

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

Re: excel export merging all the data in single column

nakuldev — Thu, 02 Jan 2020 16:21:44 GMT

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

Re: excel export merging all the data in single column

Brett_Bleess — Thu, 02 Jan 2020 16:28:38 GMT

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

Re: excel export merging all the data in single column

lorenzoconforti — Thu, 02 Jan 2020 16:56:49 GMT

see if this helps:

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

Re: excel export merging all the data in single column

nakuldev — Fri, 03 Jan 2020 03:56:12 GMT

Hi Brett,

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

Regards

Nakul

Re: excel export merging all the data in single column

lorenzoconforti — Fri, 03 Jan 2020 09:11:07 GMT

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-CSV/td-p/1517059

Re: excel export merging all the data in single column

nakuldev — Fri, 03 Jan 2020 11:33:54 GMT

Hi Lorenz,

It is helpful. Will add it to the settings.ini file and check.

Thank you

Regards

Nakul