Intellipaat Back

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

I have a tableau workbook that was given to me. I open it and I see everything there.

I want to export the data to CSV including the measures which are a bunch of sums. Right now the measures are in the right 4 'columns' but not in the column shelve.

How do I get it out into CSV format clean so that I can push it through R. This is driving me nuts...

closed

1 Answer

0 votes
by (47.2k points)
selected by
 
Best answer
  • In order to keep things clean, and save processing power, what you could do in cases like this is drag all the dimensions and measures to Detail, instead of rows or columns.

  • You can choose the Bar chart manually first. So, Tableau won't waste time processing a visualization for the data. But the data will still be there, you can right-click on the "phantom" chart, and select View Data. Everything would be there. Through the Export button, that will export to a CSV.

  • You can use tabcmd to export this data to a CSV, If you have Tableau Server

tabcmd export "worksheet-name" --csv

If you also want to learn Tableau and make your career in it then I would suggest you must take up the following Tableau Certifications course online. 

Related questions

0 votes
1 answer
asked Jul 22, 2019 in BI by Vaibhav Ameta (17.6k points)
+1 vote
1 answer
asked Oct 31, 2019 in Data Science by chandra (29.3k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...