3 Replies Latest reply on Oct 15, 2018 10:20 PM by Stefan van der Merwe

    Aggregate Text in to comma separated cells

    Lloyd Buss

      Hello,

       

      Is it possible to convert input below to the output to the right? I want to convert my python script to Tableau Prep but can't see an option for this type of aggregation.

       

      Thanks

      Lloyd

       

            

      INPUTOUTPUT
      CountryProductMetric ValuegfffffffffffffffProductRed CountriesGreen Countries
      Country 1Product 1RedProduct 1Country 1, Country 2, Country 5Country 3, Country 4
      Country 2Product 1RedProduct 2Country 1, Country 3, Country 4Country 2
      Country 3Product 1GreenProduct 3 Country 1, Country 2, Country 3, Country 4
      Country 4Product 1Green
      Country 5Product 1Red
      Country 1Product 2Red
      Country 2Product 2Green
      Country 3Product 2Red
      Country 4Product 2Red
      Country 1Product 3Green
      Country 2Product 3Green
      Country 3Product 3Green
      Country 4Product 3Green