Data Viz Done Right

March 7, 2017

Tableau Tip Tuesday: How to Export a CSV from a TDE

4 comments
Super simple, yet very useful tip this week. Here's the scenario:

  1. Someone sends you a TDE
  2. You need the raw data, but the file wasn't provided

Getting the data out is much simpler than you think.

Step 1 - Connect to the TDE



Step 2 - Add Number of Records to the Text shelf



Step 3 - Right-click on the text in the worksheet and choose View Data...



Step 4 - In the View Data window, click on the Full Data tab at the bottom.



Step 5 - Click the Export All button on the upper right



This will save all of the data as a CSV. That's it! I told you it was simple.

4 comments :

  1. Thanks for all your posts about Tableau! We also added "Export to CSV..." option on data sources in 10.2.

    ReplyDelete
  2. Is there some reason why either option doesn't always export the full number of rows? I have a ~13M rows in a TDE but can only get 800k-1.3M rows at a time

    ReplyDelete
    Replies
    1. Not sure. Why would you ever want to export 13m records from a TDE anyway?

      Delete