topic Re: Memo Field - Data not loading in QlikView

Memo Field - Data not loading

Wed, 03 Oct 2012 16:03:37 GMT

Hi,

Does anyone know if there is a limit on the amount of text qlikview can import within a memo field on a table?

I am curently experiencing problems importing a table from foxpro that includes a memo field. I have found that some fields appear blank whilst others contain the text (I have checked the actual tables and they all contain text).

I have tested over-writing the contents of memo fields with a short amount of text......this seems to work. However I get blank lines again if I overwrite with a large amount of text.

Has oneone else had the same issues?

Does anyone know if there is a way to resolve it?

Many thanks

Re: Memo Field - Data not loading

Thu, 04 Oct 2012 13:44:46 GMT

Has anyone got any ideas on this one?

I tried updating to QV11 sr2 to see if it made a difference (it didnt).

I have been looking through the forums and cannot really find anything.

Re: Memo Field - Data not loading

m_woolf — Thu, 04 Oct 2012 20:37:14 GMT

You might try loading the data into Excel to see if it is a problem with the odbc driver and not a qlikview issue.

Re: Memo Field - Data not loading

hic — Fri, 05 Oct 2012 12:39:38 GMT

There should be no limits in QlikView, but the DB or ODBC/OLEDB might have some limitations. Try with an other ODBC client like mwoolf suggests. Also, you can try to use the len() function in the script to debug:

Load *,

Len(TextField) as x; // Length of string that QlikView receives from ODBC

SQL SELECT *,

Len(TextField) as y // Length of string that DB has

...

HIC