How to export your calculations from Tableau to Excel using Python
I recently completed a Tableau project, where I had used over 100 calculated fields and parameters. What felt like completing a marathon, quickly turned into a simple warm up. That is often how data governance creeps up on you.
- Side note, my articles on Month-over-Month calculations and Market Share vs Contribution Share contains many of these calculations and if you have read them, you will feel the anxiety of needing to document them all.
Tableau does not (yet) have a way in which you can extract all these calculations, so I soon realised that I may have to knuckle down and use the old trustworthy method of copy/paste.
Plot twist. This is 2021 and there is ALWAYS an alternative solution to copy/paste.
Python is your friend. For those who still fear delving into coding, just remember that this snake does not bite. It can save you from needing to copy +100 formulas and do it for you within a minute.
Firstly, I would like to give all credit to rarandall for this python code, which I found on The Dot Viz. There are two ways in which you can use this extractor:
- If your data can be made publicly available, then you can simply upload your tableau file (in a .twb format) to their extractor.
- If your data is sensitive and not for the public eye, then use this code in your own Python script (my preferred method).
#data #data-governance #tableau #python #pandas
