How to connect to FTP with Tableau Prep

It is common to use FTP as a file transfer mechanism between businesses. Tableau Prep cant connect to FTP out of the box, but we can make it work with a free utility called FTPUSE. Install the utility and add a FTP folder as local drive by entering the below...

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

Tableau Tip: All about Leading and Trailing Zeros

Handling numbers as text for the first time in Tableau  is a frustrating experience. Depending on your requirements, you might have to add /remove  trailing/ leading zeros, modify number of decimal places etc. This post is an attempt to address the  most common scenarios. Note:  If the final result required...

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