Category: Tableau Prep

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