QlikSense: store CSV with ANSI Coding

[micheledenardi]

Dear all,

When QlikSense store table into CSV (; as delimiter ) the default codpage is UTF-8-BOM but i need to store data with ANSI codpage.

I found different solution to do this with QlikView but i didn't find any way to do this with QlikSense.

My store statement is this:

Store Material into MD_Material.csv (txt,delimiter is ';');

Is there any way to store in ANSI?

Thanks

[ArnadoSandoval · Accepted solution]

Hi @micheledenardi 

Qlik Sense STORE statement does not encode to ANSI (e.g. ASCII) you will be better off processing the output file with your preferred script tool, like Powershell, Python, C# I found plenty of references about writing these programs!

QlikView seems to support this conversion, but it is not done by the STORE statement, it is done within the script, actually it is an in-memory conversion.

Hope this helps