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.