Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (47.2k points)

I am trying to create a dashboard from the data present in the Hive. The catch is the column which I want to visualize is a nested JSON type. So will tableau able to parse and flatten the JSON column and list out all possible attributes? thanks!

1 Answer

0 votes
by (17.6k points)

  • Unfortunately Tableau will not automatically flatten the JSON structure of the field for you, but you can manually do so.

  • Here is an article that explains the use of Regex within Tableau to extract pertinent information from your JSON field.

  • I realize this may not be the answer you were looking for, but hopefully, it gets you started down the right path.

  • (In case it helps, Tableau does have a JSON connector in the event you are able to connect directly to your JSON as a datasource instead of embedded in your Hive connection as a complex field type.)

Related questions

0 votes
1 answer
asked Dec 29, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jul 23, 2019 in BI by Vaibhav Ameta (17.6k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...