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 🙂
- 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
- Use html2text to bypass tables (IGNORE_TABLES)
- 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