4 Replies Latest reply: Dec 19, 2017 11:14 PM by Luis Madriz RSS

    QlikSense : Auto trimming of spaces between text field ( Oracle DB)

    Javed Sheikh

      Hi All,

       

      I am working in qlik sense and encounter a weird problem. Details below

       

      The data coming from DB is like

       

      test:

      Load *inline

      [text

      6611

      66      11

      1166

      ];

       

      Output in Qlik Sense

      6611

      1166

       

      Qlik Sense somehow removed the spaces between the data. Just wanted to know why

       

      Your valuable help or any previous experience with similar issue will be greatly appreciated.

       

      Thanks,

      Javed

        • Re: QlikSense : Auto trimming of spaces between text field ( Oracle DB)
          Devarasu R

          Hi Javed,

           

          Because it's number field, by default while load these data it will remove the space from that number field. to prevent u can use Text function.

           

          test:

          Load text(text) as text_Revised inline [

          text

          6611

          66      11

          1166

          ];

          Capture.JPG

           

          Hope this helps to you

           

          Thanks,

          Deva

          • Re: QlikSense : Auto trimming of spaces between text field ( Oracle DB)
            Luis Madriz

            Thanks for sharing this Javed, I never noticed it.

             

            I ran other tests coming from an excel file as well and this is the conclusion I'm getting:

             

            It seems to depend on the load order: whatever you load first, then the rest that's similar will follow the "template" provide by the first... and it seems to work both ways from number to text and from text to number

            First 11 22 and then 1122 will produce 2 records with 11 22

            First 1 2 3 4 5 6 and then 123456 will produce 2 records with 1 2 3 4 5 6

            First 1122 and then 1 1 2 2 will produce 2 records with 1122

            First 123456 and then 123 4               56 will produce 2 records with 123456

             

            Even coming from different loads, one from an inline for example and the second load from an excel file for the same qlik sense table.

             

            Spooky!!!

             

            I tried to find any information about on the Help but couldn't. I hope other community members would see this and share their thoughts

             

            Thanks again Javed,

             

            Cheers

             

            Luis