Tableau Extracting Data

In Tableau, Data extraction creates a subset of data from the data source. Data extraction is useful for increasing the performance by applying filters. It also helps in using some features of Tableau. Probably, which is not available in the data source like finding the distinct values in the data. However, the data extract feature is the most commonly used to create a local drive for offline access by Tableau.

Creating an Extract

Extraction of the data is done by following the menu:

Data → Extract Data.

It creates multiple options such as applying limits to how many rows to extract and whether to aggregate data for dimensions.

The below figure shows the Extract Data option to you.

Tableau Extracting Data

Applying Extract Filters

For extract a subset of data from the data source, you can create ,filters which only return the relevant rows.

For example: The Sample Superstore data set.

  • Click on an extract data,
Tableau Extracting Data
  • Click on the Add button.
Tableau Extracting Data
  • Add any filter or select a field among all options such as sub-category and click OK button.
Tableau Extracting Data
  • Choose from the list and tick mark the checkbox value for which you need to pull the data from the source and click on the OK button.
Tableau Extracting Data

Adding New Data to Extract

Add more data for an already created extract, and you have to choose the option Data → Extract → Append Data from File.

In this case, browse the file containing the data and click on the OK button to finish. Of course, the number and data type of columns in the file should be in sync with the existing data.

Tableau Extracting Data

Extract History

You can also verify the history of data extraction to know about how many times the data extraction has happened and at what times.

For this, you have to use the menu - Data → Extract History.

Tableau Extracting Data

And then it shows you all the data extraction history.

Tableau Extracting Data




Latest Courses