Whispering Technology
Tableau Prep Python integration was added in 2019.3 and this post shows how to install and setup TabPy for Tableau Prep. Tableau recommends to run TabPy in a virtual environment and we will use Anaconda to manage our virtual environment. 1. Downloading and Installing Anaconda You can download Anaconda for...
Aggregating strings is a common task in data cleaning, but it is not yet supported in Tableau Prep out of the box. This post is inspired by a Tableau community question where a user asked help on combining data from multiple rows into a single cell. This is a more...
We can setup up a trigger to receive email alerts when ungrouped categories are detected in the flow, but how do we modify the flow to group the ungrouped categories? We will cover that in this post using the same flow used in the email trigger post. Click on the...
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...
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...
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...
Group and Replace feature in Tableau Prep is one of my favorite as it can standardize fields using many of the built-in algorithms. But it has its caveats; Algorithms are applied only to the sampled data and not to the entire data set Prep flow stores a look up table...
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...
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.
1 | powershell.exe "Invoke-WebRequest 'Google Sheet Link' -OutFile 'path/to/store/file'" |
Here are the steps to get it...
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...