adding prefix 0 while loading from SQL to Qlikview
Hi experts,
I am pulling this data from SQL into Qlikview using basic select * from abc statement. The issue is for CTCRSZ, I m getting '001' in both the rows in qlikview while in SQL one row has CTCRSZ '01' and another '001'.
CTACVL
CTCREX
CTCRSZ
CTCRTP
CTCTDS
CTCTVL
CTCTWT
3036
001
CFP
Standard Carton
3036
2
99999
DEF
001
CFP
DEFAULT CARTON
99999
0
Could you suggest how to fix the issue. Any help is much appreciated!
Hey just wanted to inform you guys, this issue was caused by some server issues that is fixed now. We are using Qlik10 and recently db folks ran some update that triggered the report distortion. I appreciate your time and effort.
