Tableau Prep – Creating Timestamp based output files

As of version 2018.3, Tableau Prep’s output file name field is static and this will cause the output data to be overwritten  when rerunning the flow.  We can fix this by creating a bat file with following content.

 

Explanation:

  • Line 2: A simple batch trick to generate our file_name variable.  You can adjust this line to fine tune your file name.
  • Line 3 : Run the actual flow from command line.  Please refer to the documentation if you need more details.
  • Line 4: Rename the Output file name with our file_name variable.

Save the bat file and double click on it. The bat file will run and output file will be created according to the timestamp.

Running the flow with bat file

Rerunning the bat file will create a new file with the new timestamp.

You may also like...

Leave a Reply

Your email address will not be published.