topic character not accepted when importing in QlikView

character not accepted when importing

Fri, 13 Apr 2012 12:39:52 GMT

Hello

I can not import the entire line of a text file
without any time to know the cause

Thanks

character not accepted when importing

Miguel_Angel_Baeyens — Fri, 13 Apr 2012 12:47:51 GMT

Hi,

Can you please elaborate on what you are trying to load and post some example of data that is not working as expected?

Miguel

Re: character not accepted when importing

Fri, 13 Apr 2012 13:27:58 GMT

thanks

Re: character not accepted when importing

Fri, 13 Apr 2012 13:54:30 GMT

The attached file loads nicely in qlikview.

The weird "square" characters that appear in column #8 are already present in your factures text file.

If your factures text file was exported from a database that uses an UTF-8 character set (let's say an oracle database that uses AL32UTF8 instead of ISO-8859-P / WIN1251 character set), you might consider connecting directly to the database or asking for a new export in UTF-8 format, in order to preserve accents / diacritic characters.

Hilaire