3 Replies Latest reply on Sep 17, 2018 6:46 AM by Marlou Lemmer

    Tableau Prep not creating all Pivot Columns

    Marlou Lemmer

      Good day,

       

      I hope someone can help me. Not sure if I'm doing something wrong.

      I'm adding about 48 excel files through wildcard join, I then pivot about 30 of the columns using a pivot flow.

      After waiting for the flow to run, only 14 of the columns are returned as rows, the rest of the new row values disappears.  It looks as if the values are combine, since the amount of rows are not less. I un-ticked the "Automatically rename pivoted fields and values", doesn't seem like this is doing anything.

       

      Thanks!