4 Replies Latest reply: Aug 4, 2015 12:26 PM by Jason Wills RSS

    Data Manipulation on Import

    Jason Wills

      Hi All,

       

      I have been following some threads on here on importing data into Qlik, and so far it is great (am new to all of this.)

       

      However, I have come up against something I'm not sure how to do, so was hoping someone can help..

       

      When importing the data, it is coming from excel - the text in question has some text in brackets at the end of the cell e.g.

      Testing123 (test)

       

      what I'm trying to achieve is when I import data, it drops the brackets, so I will only get Testing123 - I know this is possible in excel, but I am trying to avoid manipulating the data in excel, as there are other things going on with it, so am trying to do it on import.

       

      I will keep looking, but if anyone can help, I would appreciate it.

       

      Many Thanks

       

      Jason