14 Replies Latest reply on Jun 10, 2016 6:58 AM by Toby Erkson

    SUM   SPLIT  STRING?

    wasan chaichana

      excuse me. in Tableau Desktop + Hadoop, I want to know how to substring and sum the number of text of each rows like row 1

       

      "10.00_PM001,23.50_PM002,17.00_Pr001,24.50_Ps002,11.00_PM001,13.50_PM002"

       

      the result i wanted is the sumation of (10.00 + 23.50 + 17.00 + 24.50 + 11.00 + 13.50)

       

      i've attached an exsample file that contains many rows of text, plese help and sorry for my English.

       

       

       

      EX:   (FLOAT(SPLIT([Column5],'_',1)) + FLOAT(SPLIT(SPLIT([Column5],',',2),'_',1)))

       

       

       

       

      ข้อความถูกแก้ไขโดย: wasan chaichana