Category: Tableau Prep

Tableau Prep Email Alerts

In  future proofing group and replace post, I promised to write about generating an email alert when ungrouped data is detected by the flow. We will use that scenario for this post, but the same technique can be applied for a wide variety of other scenarios as well. Unfortunately Tableau...

Tableau Prep – Future Proofing Group and Replace

In the last post, I shared a tip to to ensure  guaranteed grouping on all existing data in a data set. But what if your flow is scheduled to run every week or every month? Will the new data break your carefully designed dashboard? To ensure that only grouped that...

Tableau Prep – Connecting to REST API

Tableau Prep or Tableau does not have A built in rest API connector, but we can download data from rest API using  Power Shell and pass it to  Tableau Prep Flow. We will be using  IEX Share price API for the purpose of this demonstration. Try the below one liner...

Tableau Prep – Connecting to Google Sheets

As of version 2019.1.3, Tableau Prep does not have a builtin Google sheets connector, but it is not a problem if you are running your flows from command line.  We  can can download the sheets data using below one liner.

    Here are the steps to get it...

Running Tableau Prep Flows From Windows Context Menu

In a previous post, we discussed about enabling drag and drop execution for Tableau Prep flows, but what if you can run the flow from any folder by simply right clicking and selecting “Run Flow” ?   This is done using  a simple registry trick. Save the below lines in...

Workaround for wildcard union refresh limitation of Tableau Prep

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

Tableau Prep – Running multiple flows with drag and drop

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

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