adding prefix 0 while loading from SQL to Qlikview
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'.
Could you suggest how to fix the issue. Any help is much appreciated!