topic Re: Data transformation error after loading negative amount with decimals in QlikView

Data transformation error after loading negative amount with decimals

Wed, 06 Mar 2013 14:05:35 GMT

Hi,

I stumbled upon a problem, Qlikview seems to reformat data i read from a view in my SQL database.

My load script leaves the data unchanged:

LOAD LEDGERTRANSDATE,

PROJID as PTP_PROJID,

VOUCHER,

TRANSID,

PROJTRANSDATE,

DIMENSION as Afdeling,

"DIMENSION2_" as Kostenplaats,

"DIMENSION3_" as Doel,

PROJTRANSTYPE as TRANSACTIETYPEID,

AMOUNTMST,

OFFSETACCOUNT;

SQL SELECT *

FROM MRPRJPROJTRANSPOSTING;

Looking at the data from within SQL Server, i see the following:

The AMOUNTMST field after loading in Qlikview shows the following:

So the first number seems to be rounded, but as for the second number i haven't got a clue.

Any suggestions anyone?

Kind regards,

Herman

Re: Data transformation error after loading negative amount with decimals

m_woolf — Wed, 06 Mar 2013 14:54:28 GMT

In the first picture the Account is 08510.

In the second picture it is 013211.

Are you looking at the same numbers?

Re: Data transformation error after loading negative amount with decimals

Wed, 06 Mar 2013 15:14:43 GMT

Right.... In the connection string a different database was attached. Because most id's are the same (one db being a clone of the other), i didn't notice this. Thank you!

This makes a fine first post....