Techno Whisp

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 …

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…

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…

Update: With the release of Tableau Prep 2018.3.3, Wildcard union files are refreshed automatically and the workaround mentioned in this post is no longer required. If you are using Tableau…

In the last post, we discussed about drag and drop execution of Tableau Prep flows. But what will happen if you dropped multiple files?  The previous version will only run…

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

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…

Creating unique Row IDs in Tableau Prep is not something that is available out of the box, but you can  use below workaround for the same effect. This is an…

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…

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,…