Tableau Prep Tableau Prep – Connecting to Google Sheets Apr 4, 2019 Jose CherianAs 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 …
Tableau Tableau Tip: All about Leading and Trailing Zeros Mar 30, 2019 Jose CherianHandling 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…
Tableau Prep Running Tableau Prep Flows From Windows Context Menu Mar 16, 2019 Jose CherianIn 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…
Tableau Prep Workaround for wildcard union refresh limitation of Tableau Prep Dec 16, 2018 Jose CherianUpdate: 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…
Tableau Prep Tableau Prep – Running multiple flows with drag and drop Dec 15, 2018 Jose CherianIn 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…
Tableau Prep Tableau Prep – Enabling drag and drop execution of flow files Dec 15, 2018 Jose CherianHow 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. …
Tableau Prep Tableau Prep – Creating Timestamp based output files Dec 12, 2018 Jose CherianAs 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…
Tableau Prep Creating unique Row IDs in Tableau Prep Dec 11, 2018 Jose CherianCreating 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…
Tableau Automatically loading the latest file from a folder in to Tableau Nov 17, 2018 Jose CherianIf 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…
Tableau Using Open StreetMap in Tableau Oct 1, 2018 Jose CherianThe 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,…