1 Reply Latest reply: Sep 30, 2016 2:17 PM by Sunny Talwar RSS

    Load field only up to comma

    james eckstein

      I have  a field a table that looks like this.

       

      IDType

      300

      Jim,Dave,Scott
      500Ron,Betty,Jeff
      600Sara,Nick,Nick

       

       

      When loading into Qlik I need only the charteres to the left of the first comma in the type column. The result should look like this.

       

      IDType
      300Jim
      500Ron
      600Sara

       

       

      Any help??

       

      Thanks in advanced.