Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

11 Replies
Not applicable
Author

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

ArnadoSandoval
Specialist II
Specialist II

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

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.