8 Replies Latest reply: Nov 1, 2018 8:00 PM by Fei Xu RSS

    How to load in 3.00 as a string, not a number

    Xavier Wiltbank

      I'm having issues with my load script loading in what would look to be a numerical field.

       

      I have a file with a column "Field1"

      Where Field1 has the values

      Field1

      1

      2
      898
      3.00
      3.01

       

      I'm essentially running:

       

      Load

           Text(Field1) as Field1

      From File

       

      When the data loads in, I get 1, 2, 898, 3, 3.01

       

      I want the 3.00 to load in as a string (I want all of these to load in as a string.)

       

      But Qlik Sense chops off the .00, which would make sense if I was loading in as a number, but I want to specify Text. Is there a way to do this?

       

      Thanks!