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...
Monthly Archive: April 2019
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.
powershell.exe "Invoke-WebRequest 'Google Sheet Link' -OutFile 'path/to/store/file'"
Here are the steps to get it...