Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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