Category: Tableau Prep

Tableau Prep – Enabling drag and drop execution of flow files

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

  Explanation: line 1:¬† Extract the dropped file’s...

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...

Creating unique Row IDs in Tableau Prep

This is an extension to the ranking trick in Tableau Prep. Lets see how we can get unique row ids for below data. Before going ahead, we need to make sure that there is a field that uniquely identifies each row. In our case, we can use the Name field,...