11 Replies Latest reply: May 2, 2016 2:17 PM by Rupesh Bharadwaj RSS

    adding prefix 0 while loading from SQL to Qlikview

    Rupesh Bharadwaj

      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'.

       

             

      CTACVLCTCREXCTCRSZCTCRTPCTCTDSCTCTVLCTCTWT
      3036                                                 001CFPStandard Carton30362
      99999DEF001CFPDEFAULT CARTON999990

       

      Could you suggest how to fix the issue. Any help is much appreciated!