Text field load problems - Qlik Community

Report Inappropriate Content · ‎2011-11-01

Hi All,

I have a text field in my data that has a lot of complicated symbols and is really long. When read into QV it seems to get truncated and has caused major problems in the other fields in my data. Are there any symbols or anything that are not allowed in Text fields in QV? Anyone had similar problems?

Thanks

Gareth

Report Inappropriate Content · ‎2014-03-13

Hi

I have a similar problem. Have you fixed? how?

thans

luca

m_woolf · ‎2014-03-13

In the File Wizard, try checking Ignore EOF

Report Inappropriate Content · ‎2014-03-13

Thanks, Michael, but I use ODBC and I take the field from a database

luca

hps · ‎2014-03-13

How long are the strings from the database?

There is a field length limit that come into play.

Report Inappropriate Content · ‎2014-03-13

66 char the string in database, 40 in QW