0 Replies Latest reply on Nov 29, 2018 1:32 PM by Martin Sellers

    Tableau Prep: Concatenating many to one into new calculated field

    Martin Sellers

      Hi-

      I am working in Tableau Prep and am wondering how to created a specific kind of calculated field output.  In the below example, my aim is to create a new calculated field that will concatenation all "schedule_codes" that have the same "full schedule".

      The many to one relationship is "Full Schedule"----> "Schedule_Code"

       

      For example, in the highlighted grouping shown below (2 rows), for every full schedule "Sunday (06:00-00:00-......)", I want the new calculated field to produce "XIJ, XQ1".

       

      I want this to happen for all possible groupings many to one relationships.

      Thanks!

       

       

      Capture.PNG