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

Creating unique Row IDs in Tableau Prep

This is an extension to the ranking trick in Tableau Prep. Lets see how we can get unique row ids for below data. Before going ahead, we need to make sure that there is a field that uniquely identifies each row. In our case, we can use the Name field,...

Automatically loading the latest file from a folder in to Tableau

If you have a folder where files are added daily, how do you load the latest file automatically in to tableau? I recently answered a stack overflow question  and this post is an attempt to explain the other aspects that is not covered on that answer. Basic Setup If you...

Using Open StreetMap in Tableau

The default map in Tableau is good for showing overall locations, but it cant be used to zoom in to specific streets or buildings in your locality. But dont worry, you can use Open StreetMap for that. Download this file and save it under Mapsources folder in your Tableau repository.  Default location...

Predicting Dam Water Levels Using Tableau

My home state is going through a crisis right now as the largest arch dam in Asia , Idukki Dam is reaching its full reservoir capacity due to unprecedented monsoon rains.  All 5 shutters were opened on 10th August and is still releasing water at a rate of 0.75 million liters ...

JIRA to Tableau in two lines of Python

Recently, I had to create one  status dashboard for a JIRA project.  Tableau does not connect to JIRA out of the box and you need to purchase a connector to get  this functionality.  Since JIRA has a  REST API, my initial instinct was to build a web data connector. But ...

Dynamic PWA Manifest

Recently I saw an interesting stack overflow question that asks about changing the PWA icon dynamically based on the page url. Some of the comments are pointing in the right direction (serve the manifest dynamically) which increased my curiosity. Here  is a sample APP I created just to try it...

Developing AngularJS Apps with VS Code

If you are switching from Brackets to VS Code for your AngularJS development, the first thing you are going to miss is the live preview option. VS Code does not have a built in server that can be easily activated. While there are 101 ways to run a local server,...

Microsoft announce official support for VSCode Python

Last week saw an interesting announcement from Microsoft MSDN blog. It announced that  Don Jayamanne, creator of the Python extension for Visual Studio Code joined Microsoft.  I was always impressed with the simplicity and usefulness of this extension and already wrote a blog post on that.  Don definitely deserve this recognition...