topic Re: Export to skv file in App Development

Export to skv file

niranjana — Mon, 11 Mar 2024 08:30:44 GMT

Hi,

I want to export Qlik straight table to skv file. When I export to excel, there are no double quotes in the fields. But When i export it to .skv file fomat, some values in some fields appear with double quotes " (with or without macro).

I used purgechar for those fields but no use.

What could be the reason . Is any correction to be done?

Thanks

Niranjana

Re: Export to skv file

marcus_sommer — Mon, 11 Mar 2024 11:20:02 GMT

It's caused from the export-library which adds quotes if the field-values contain quote-chars. AFAIK there is no way to customize the behaviour like you could do it by loading such files.

Many import-logic from third party-tools could handle field-values with and without any quoting - therefore you may just a bit playing with them. If it's not working you may consider to replace these quotes completely in Qlik before exporting the data or to change them in some way maybe from double-quotes to single quotes or revers to ensure that there is no kind of quote-duplicating or replacing them with unique char which could be transformed later within the target-system. Further measures may be to unify it for all fields - means field-values without a quoting get an extra quoting.

Re: Export to skv file

niranjana — Tue, 12 Mar 2024 07:09:03 GMT

Hi,

Thanks for your reply. But it doesnt answer my question. In excel file, it doesnt appear. When I copy that text alone and paste in notepad , it appears with double quotes.

Also, When i export the Qlik chart to .SKV file format, double quotes appears for some values in that field but not all values. The field is Hospital address.

For example :

hospital address

"mohak, 30 , flat 34"

ajay, 20,ghats

Thanks

Niranjana

Re: Export to skv file

marcus_sommer — Tue, 12 Mar 2024 08:42:43 GMT

Excel isn't a valid tool to look on the underlying data because it will always interpret the data - depending on the releases, the region-settings and other things without a real customization (at least within the automatic mode - by copying the entire data into a single column and then using the feature "text in columns" there are various options available).

If notepad showed quotes there are real quotes in the export-file.