Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
While loading use Text in front of AcctCode.
Text(AcctCode) as AcctCode
While loading use Text in front of AcctCode.
Text(AcctCode) as AcctCode
Thank you, exactly what I needed