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

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