I was working on Tableau to show some records that were extracted from a database, one of the columns is a HTML document, unfortunately Tableau cannot show HTML data properly.

I did my research but found no solution, someone in Tableau community raised this requirement years ago but it’s never been supported (someone mentioned Tableau extension but after a quick look I didn’t feel it’s practical when your enterprise Tableau is managed by IT, plus writing an extension simply doesn’t look elegant)

I came to the following solution for now, if you have a better solution, please let me know 🙂

  1. Use Python library html2text to convert HTML into text. Output of tables by htmt2text is ok but not good, use the below to do more work if needed
  1. Use html2text to bypass tables (IGNORE_TABLES) 
  1. Use BeautifulSoup to extract tables out of the data(soup.findAll(“table”)); then use Prettytable to print them in Ascii. You will lose the original positions of tables so this is not perfect

Tableau to show HTML data
Tagged on:                 

Leave a Reply

Your email address will not be published. Required fields are marked *

21 + = 31

This site uses Akismet to reduce spam. Learn how your comment data is processed.