8 Replies Latest reply: Nov 20, 2014 9:03 AM by Ruben Marin RSS

    Extract an number wich begin by an 0 as an string

      Hello,

       

      i met an problem i have in a customer table an strange id.

      It s an number wich begins by 0 so for two customer :

       

      customer A  id = 133

      customer B id =  0133

      customer C id =  0133


      But the problem is that qlikview, when i extract the data, considers that the id is an number.

      So after the extraction of the data, i have in my qvd data the id for  the 3 customer


      customer A id=133

      customer B id =  133

      customer C id =  133

       

      how to fix that problem and to get qlikview consider the id as an string ?

       

      Thanks