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.

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,

Click on the Add button.

Add any filter or select a field among all options such as sub-category and click OK button.

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.

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.