Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Special characters on Excel

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.

Tags (2)
11 Replies
MVP & Luminary
MVP & Luminary

Re: Special characters on Excel

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

- Marcus

Not applicable

Re: Special characters on Excel

Hi Marcus,

Nothing happens, I mean is the same...

MVP & Luminary
MVP & Luminary

Re: Special characters on Excel

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

Not applicable

Re: Special characters on Excel

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

MVP & Luminary
MVP & Luminary

Re: Special characters on Excel

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

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

- Marcus

Not applicable

Re: Special characters on Excel

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.

loadexcel.jpg

Highlighted
MVP & Luminary
MVP & Luminary

Re: Special characters on Excel

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

Not applicable

Re: Special characters on Excel

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.

tinaco110
Contributor III

Re: Special characters on Excel

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

QVC-2016-11-21.png