4 Replies Latest reply on Mar 26, 2020 6:15 PM by Santiago Sanchez

    Tableau Prep 3M+Rows

    Ryan Morrison

      Report: Ticket Detail Transaction Report

      Cadence: Monthly

      Range: Start of Month - End of Month

      Results 300k+ lines of detail for each month

       

      I've been exporting each monthly report into a folder and then allowing TPrep combine all the files, clean the data, and export to TDE. However, now with two years of data and over 3M records the flow is taking a long time. I'm looking for suggestions on best practices.

      I was thinking about running each monthly report through Tprep and creating it's own TDE file. Then create another flow that combines each TDE. I'm very new to this so any suggestions would be great!

       

      Thanks,

      Ryan