6 Replies Latest reply: Dec 12, 2015 12:08 PM by Massimo Grossi RSS

    split a column into new columns by character in qliksense

      Hi all,

       

      I have a csv file with a specific field like this:

       

      TYPE
      
      AT IT BA
      IT BA
      AT BA LB
      RT LB
      


      I want to create something like:

       

      TYPE                  OPTION1              OPTION2               OPTION3
      
      AT                    IT                   IT                    BA
      IT                    BA
      AT                    BA                   LB
      RT                    LB
      

       

      How i can do it?

       

      Thanks!