topic Re: Reading *.cvs files questions in QlikView

Reading *.cvs files questions

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I'm testing Expressor reading *.csv files, and I have some issues. First I'm using encoding UTF-8 but it is not been recognized special characters like "ñ"or "é", The other issue is when I create the schema, my two columns (Codigo and Nombre) are merge in a single field. There are two pics showing this.

Anyone can help me please?. Thanks in advance

Re: Reading *.cvs files questions

Michael_Tarallo — Mon, 08 Oct 2012 20:13:05 GMT

It appears that your file is semi-colon delimited - but the screen shows you are using a comma. Can you change that to a semicolon and retry?

Re: Reading *.cvs files questions

Tue, 09 Oct 2012 14:01:44 GMT

Hi Mike!

You' were right about the semi-colon delimited, I've changed and it shows my 2 fields.

About the special characters like ñ and "josé", do you know how can I solve this?

Regards,

Ma. Jose

Re: Reading *.cvs files questions

Michael_Tarallo — Tue, 09 Oct 2012 14:06:23 GMT

Hello Jose -

Cool.

I have reported that to our engineering team - I have seen this before - I believe you may need to use and ISO-8859-x setting. I'll let you know.

Regards,

Mike T

Re: Reading *.cvs files questions

Michael_Tarallo — Tue, 09 Oct 2012 14:17:49 GMT

I just tested this in a simple Dataflow - attached at bottom of discussion - it worked for me using UTF-8 schema setting with QlikView Expressor Desktop 3.7.1.

Simple Data file:

name,age

mikeñ,43

josé,23

Test my sample and let me know.

Note: The attached .csv file was created in Notepad ++ and showed ANSI as the default encoding - I saved it as UTF-8 and the characters changed to corresponding codes such as xF1 XE9 - and it still worked.

Let me know.

Mike T

Re: Reading *.cvs files questions

Tue, 09 Oct 2012 14:40:52 GMT

Hi Mike,

I've tested your example but I didn't work. I was looking for the encondig that qlikview uses to load my data from the .csv and it is western europe encondig that is ISO 8859-3 in expressor, I set it that way and worked fine.

I attached my excel file if you wanna test it in your project

Thanks for your help,

Maria Jose

Re: Reading *.cvs files questions

Tue, 09 Oct 2012 14:45:38 GMT

I didn't see your answer below about ISO 8859-3... thanks

Re: Reading *.cvs files questions

Michael_Tarallo — Tue, 09 Oct 2012 14:46:23 GMT

OK Cool - so the Encoding setting "is" very important - the product does not auto-recognize that by default.

So you are good with this for now?

Mike T

Re: Reading *.cvs files questions

Tue, 09 Oct 2012 14:48:20 GMT

Yeah! .. all is working Thanks