topic Value in access is changed when loaded in Connectivity & Data Prep

Value in access is changed when loaded

Michiel_QV_Fan — Thu, 23 Feb 2023 15:55:49 GMT

In access I have value 46 with field settings: text.

Loading with QlikView 12 the value is stored in QVD as 046.

The load has no transformations. Pure ODBC to access, load * and store.

I have no clue why this happens.

Re: Value in access is changed when loaded

marcus_sommer — Tue, 28 Feb 2023 15:44:51 GMT

Qlik doesn't have data-types else the data will be interpreted as string, numeric or dual() - mainly based on the first field-value. In the most scenarios this worked well but in some cases mostly with leading spaces or zeros it may not fit to the wanted results. In such cases the field might be wrapped with a text() function, for example:

load text(field) as field; sql select field from db;

Re: Value in access is changed when loaded

Michiel_QV_Fan — Wed, 01 Mar 2023 08:16:42 GMT

Indeed. This post was found by a colleague.

https://community.qlik.com/t5/Official-Support-Articles/Leading-zeros-are-missing-in-loaded-data-values/ta-p/1711882