7 Replies Latest reply on May 2, 2018 9:55 AM by Deepak Rai

    Concatenate strings from one ID within calculated field

    Maximilian Haberland

      Hi everybody,

       

      Im looking for a way to concatenate strings (from different rows) for one ID within a calculated field.

       

      My data looks somewhat like this:

       

      ID         String         

      1          apple        

      2          pear

      3          carrot

      4          apple

      2          banana

      3          pineapple

      5          carrot

       

      In the calculated field I would like to see something like this:

       

      ID         String          Calculated Field

      1          apple            apple

      2          pear             pearbanana

      3          carrot           carrotpineapple

      4          apple            apple

      2          banana         pearbanana

      3          pineapple     carrotpineapple

       

      My goal is identify a certain string (e.g. pearbanana) and be able to delete it form my visaulization within the dashboard via a filter.

       

      Thank you for your answer!