Missing zeros in field loaded

Anonymous — Thu, 15 Mar 2018 20:35:43 GMT

Hello,

I'm having a strange problem, I am loading this big set of data, these are accounts, I have a field AcctCode, this is a unique code, when I load it in Qlikview for some accounts it cuts one 0 from the front of the account, that make for a whole lot of confusion, now I have the same code for 2 accounts, and this happens with a lot of accounts.

For example I have an account 0022531 and one 00022531 in a SQL db, when loading it in Qlikview it registers both accounts with code 0022531. This makes the orders register twice for both accounts, which is not correct. Anybody else having this issue? Or any ideas why this would happen and how to fix?

I am running version 12.20.20400

Thank you.

Re: Missing zeros in field loaded

MK_QSL — Thu, 15 Mar 2018 21:00:12 GMT

While loading use Text in front of AcctCode.

Text(AcctCode) as AcctCode

Re: Missing zeros in field loaded

Anonymous — Thu, 15 Mar 2018 21:14:14 GMT

Thank you, exactly what I needed

topic Missing zeros in field loaded in QlikView

Missing zeros in field loaded

Re: Missing zeros in field loaded

Re: Missing zeros in field loaded