1 Reply Latest reply on Nov 23, 2018 9:32 PM by Ankit Bansal

    From split fields data to single data line?

    Naiffer Romero

      Hey Guys,

      I need your assistance as I get familiarize with Tableu Prep...

      I have a data set that looks something like this:

      Company     Product

      x                    Coffee / Tea

      y                    Coffee

      z                    Tea

       

      By using split I was able to produce the following

      Company      Product Split1     Product Split2

      X                    coffee               Tea

      Y                    Coffee

      Z                    Tea

       

      Now I need a way to consolidate all the splits in single rows

      Company     Product

      X                    Coffee

      X                    Tea

      Y                    Coffee

      Z                    Tea

       

      Thanks,

       

      -NR