topic Re: Special characters on Excel in Connectivity & Data Prep

Special characters on Excel

Wed, 09 Nov 2016 14:38:40 GMT

Hi,

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

For example:

Selecting data generates the following code

LOAD

Service,

"SA2505 Site Name",

"SA2525 City",

"SA2535 Region",

"SA2540 Estado",

o, -> It should be SA4508 Dueño

SBE_EP,

SBE_NTW,

"SBE_Tipo de Servicio",

"SBE_Sub 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

Many thanks.

Re: Special characters on Excel

marcus_sommer — Wed, 09 Nov 2016 19:26:18 GMT

What happens if you used: load * from ExcelFile; ?

- Marcus

Re: Special characters on Excel

Wed, 09 Nov 2016 19:32:05 GMT

Hi Marcus,

Nothing happens, I mean is the same...

Re: Special characters on Excel

marcus_sommer — Thu, 10 Nov 2016 05:53:40 GMT

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.

- Marcus

Re: Special characters on Excel

Fri, 11 Nov 2016 13:05:38 GMT

Marcus, how can I do to load file as flat-file?

Re: Special characters on Excel

marcus_sommer — Fri, 11 Nov 2016 13:46:54 GMT

Here are many resources for data-loading (and other stuff):

https://community.qlik.com/docs/DOC-6932#dataloading

- Marcus

Re: Special characters on Excel

Fri, 11 Nov 2016 18:04:08 GMT

I prefer to avoid loading data by ODBC. Is there any place to configure character encoding, I mean UTF,Unicode,etc. because I think that this is the problem.

Re: Special characters on Excel

marcus_sommer — Sat, 12 Nov 2016 10:18:34 GMT

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.

- Marcus

Re: Special characters on Excel

Mon, 14 Nov 2016 13:12:45 GMT

I tried changing OS region-settings but doesn't work. If I copy the content manually to another excel it works but is a little bit annoying to final user.

Re: Special characters on Excel

ArnadoSandoval — Mon, 21 Nov 2016 06:31:54 GMT

Hi Damian

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)"

Re: Special characters on Excel

Thu, 24 Nov 2016 13:23:25 GMT

Thanks Arnaldo. I don't think so because if I try with another excel file with "ñ" it works. Anyway I will try it.

Re: Special characters on Excel

ArnadoSandoval — Thu, 24 Nov 2016 13:28:39 GMT

Damian, Are they the same version of Excel? Are these Excel installed on the same version of Windows? people at the office are experiencing issues between Excel 10 and Excel 13 -- unrelated to QlikSense -- but, Excel has its own oppinionated personality