Whispering Technology
Update: With the release of Tableau Prep 2018.3.3, Wildcard union files are refreshed automatically and the workaround mentioned in this post is no longer required. If you are using Tableau Prep for long enough, you might have run in to an issue where the new files are not picked up...
In the last post, we discussed about drag and drop execution of Tableau Prep flows. But what will happen if you dropped multiple files? The previous version will only run the first file, but we can easily modify it to run any number of files. Here is the modified...
How good it will be if you can simply drag and drop a flow file to run it? Actually it can be achieved with a single line BAT file. How to achieve this? Here is the code inside FlowRunner.BAT file
1 2 | call "C:\Program Files\Tableau\Tableau Prep 2018.3\scripts\tableau-prep-cli.bat" -t "%~1" pause |
Explanation: line 1: Extract the dropped file’s...
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.
1 2 3 4 | @echo off for /f %%i in ('powershell -command "$(get-date -f yyyyMMdd_HHmmss)"') do set file_name=Output_%%i.csv call "C:\Program Files\Tableau\Tableau Prep 2018.3\scripts\tableau-prep-cli.bat" -t "C:\Automation\sample.tfl" ren Output.csv %file_name% |
Explanation: Line 2: A simple batch trick to generate our...
Creating unique Row IDs in Tableau Prep is not something that is available out of the box, but you can use below workaround for the same effect. This is an extension to the ranking trick in Tableau Prep. Lets see how we can get unique row ids for below data....