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


      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.