Discussion board where members can learn more about Qlik Sense Data Connectivity.
Im trying to load an excel file with special characters in fieldnames and possible values but QSense doesn't recognize it and gets trunk it
Selecting data generates the following code
"SA2505 Site Name",
o, -> It should be SA4508 Dueño
"SBE_Tipo de Servicio",
"O)" -> It should be SBE_Planeamiento Mensual Cliente (AÑO)
The same is happening in values.
Any help on getting through this? I've created an ODBC connector for each file but is very annoying
If possible try to load the excel as flat-file otherwise you need adjustments to the used charset within the driver or maybe a different one, see: LIB CONNECT TO odbc Codepage is not work.
I don't think that there is a possibility to adjust the excel flatfile-load in opposite to a odbc-load.
Alternatives might be to change the OS region-settings (see here what is meant: Search - But what shall you find?) or to open the excel and copy or write the content (manually or with any macro-stuff) into another file-format like csv.
It seems your problem is with the Spanish version of Qlik Sense you are using, or a translation glitch with yours, as I tried without any drama using the English version (downloaded a couple of weeks ago), take a look at the screenshot below; my XL file has a column named DUEÑO and data using the ñ character.
I even tried your column name: "SBE_Planeamiento Mensual Cliente (AÑO)"