VizWiz

Launch, grow, and unlock your career in data

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. UnknownMarch 9, 2017 at 6:56 PM

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

    ReplyDelete
    Replies
    1. VizWizMarch 13, 2017 at 3:40 PM

      Sweet! Thanks Dan! I wasn't aware of that.

      Delete
  2. chennyboy2002August 28, 2017 at 3:15 PM

    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. VizWizAugust 28, 2017 at 4:21 PM

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

      Delete

Subscribe to: Post Comments ( Atom )