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