topic INCLUDE-statement file formatting errors in Connectivity & Data Prep

INCLUDE-statement file formatting errors

NathalieLuna — Tue, 28 Dec 2021 20:28:00 GMT

Hi guys!

I have previously used the Include-statement to include centrally controlled script-snippets, e.g. variables or locale-info or even full load scripts without issues.

So far, the files have been in English only. But now, they also contain some special characters from Swedish, e.g. å, ä, ö. The txt-file I am trying to include is saved in UTF-8 format and renders well outside of Qlik Sense. But when running the script now I get errors due to the fact that the data field eg. is called "År" and Qlik is trying to (via the txt file script) pull "Ã...r".

Same result nomatter if I use Include or Must_Include.

Is there any way of telling Qlik that it is looking at UTF-8 formatting or is there some other fix for this?

Re: INCLUDE-statement file formatting errors

fosuzuki — Fri, 07 Aug 2020 08:28:00 GMT

Hi,

see if this helps you: https://community.qlik.com/t5/QlikView-Scripting/How-can-I-use-include-files-saved-in-UTF8/m-p/428584

Re: INCLUDE-statement file formatting errors

NathalieLuna — Fri, 07 Aug 2020 08:42:58 GMT

Thank you, yes it did!

The BOM-header requirement is a bit of a special thing 🙂

In case that post is deleted due to old age, I'm adding a pic of his solution here: