Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the first picture the Account is 08510.
In the second picture it is 013211.
Are you looking at the same numbers?
In the first picture the Account is 08510.
In the second picture it is 013211.
Are you looking at the same numbers?
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....