Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kkmoraes
Contributor III
Contributor III

Encode error when reading script with must_include

Hello everyone, I'm having problems when trying to read some files using must_include,
I would like your help to solve.

I have some generic scripts that I'm reading like this:

NaturezaDespesa:
Mapping
LOAD
    Natureza_Despesa_Cód,
    Item_Despesa_Nome
FROM
$(vLoadDadosVitor)CADASTROS_FNTDET_NATDESP_NATREC\Item_Despesa.qvd
(qvd);
   
 Elemento:
Mapping
LOAD
    Elemento_Despesa_Cód,
    Elemento_Despesa_Nome
FROM
$(vLoadDadosVitor)CADASTROS_FNTDET_NATDESP_NATREC\Elemento_Despesa.qvd
(qvd);

 

this script is in a separate .qvs, I'm reading the data as follows:

LET v04_00_carga_bd_fatos_bases_gct = '...carga_bd_fatos_bases_gct.qvs';
$(must_include='$(v04_00_carga_bd_fatos_bases_gct)');

 

But I'm having a problem, which I believe is related to the encode at the time of reading,
Qlik is having problems reading accented characters and it is returning an error message that the field does not exist,
because it is breaking with the character set


ex:

Cód
Ação

If I read the script directly in qvw without being via include, it works normally,
does anyone have any solution?

I'm attaching an image with the error to make it easier to understand

Thanks!

Labels (1)
1 Solution

Accepted Solutions
kkmoraes
Contributor III
Contributor III
Author

For future reference, @vadimtsushko 's answer helped me
He was having the same problem, and found that he needed to convert the file into UTF-8 BOM format.

I did the same here and it worked

https://community.qlik.com/t5/QlikView-App-Dev/How-can-I-use-include-files-saved-in-UTF8/m-p/428584

View solution in original post

1 Reply
kkmoraes
Contributor III
Contributor III
Author

For future reference, @vadimtsushko 's answer helped me
He was having the same problem, and found that he needed to convert the file into UTF-8 BOM format.

I did the same here and it worked

https://community.qlik.com/t5/QlikView-App-Dev/How-can-I-use-include-files-saved-in-UTF8/m-p/428584