# Cleaning data with Data Interpreter, pivot and split

*Tableau Data Analyst Study Guide · Connect To and Transform Data · Last updated October 29, 2026 · https://www.certifyforce.com/study-guide/tableau-data-analyst/connect-to-and-transform-data/cleaning-data-with-data-interpreter-pivot-and-split*

Name the data quality problem (completeness, consistency, accuracy), then fix it in Tableau Desktop: Data Interpreter and found tables for messy files, Pivot for crosstabs (or custom SQL elsewhere), automatic versus custom split, and Data pane folders.

- Certification: Salesforce Tableau Data Analyst
- Exam section: Connect To and Transform Data
- Study guide: https://www.certifyforce.com/study-guide/tableau-data-analyst

**Official exam objective:**

> Prepare data for analysis: Assess data quality (completeness, consistency, accuracy); Perform cleaning operations; Organize data fields into folders; Use multiple data sources (establish relationships, create joins, union tables); Prepare data by using Data Interpreter, pivot, and split; Create extract and data source filters.

## What the exam expects

- Classify a data problem as completeness, consistency or accuracy.
- Clean a messy file with Data Interpreter and fix a found table's range.
- Pivot crosstab columns into rows, or use custom SQL where Pivot is missing.
- Choose automatic Split or Custom Split, and predict the type and limits of the fields they create.
- Organize the Data pane into folders. Relationships, joins, unions, and extract and data source filters are taught in Relationships, joins, unions and data source filters (basics: the Desktop Foundations units Relationships versus joins in the data model and Join types and unions in the physical layer).

Key terms:
- **Completeness:** the degree to which all required data is known.
- **Consistency:** data agreeing within one dataset and across datasets.
- **Found table:** a sub-table Data Interpreter detects inside a sheet.
- **Pivot Field Names / Values:** the two columns a pivot creates from headers and values.
- **Custom split:** a split where you set the separator and occurrences.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Completeness | The degree to which all required data is known | [Guide To Data Cleaning](https://www.tableau.com/learn/articles/what-is-data-cleaning) |
| Data Interpreter sources | Excel (.xls, .xlsx), Text (.csv), PDF, Google Sheets | [Clean Data with Data Interpreter](https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm) |
| Wrong found-table range | Edit Found Table on the table's drop-down arrow | [Clean Data with Data Interpreter](https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm) |
| Grid Pivot sources | Excel, text file, Google Sheets, .pdf; others use custom SQL | [Pivot Data from Columns to Rows](https://help.tableau.com/current/pro/desktop/en-us/pivot.htm) |
| After a pivot | Original columns are replaced; old references turn red | [Pivot Data from Columns to Rows](https://help.tableau.com/current/pro/desktop/en-us/pivot.htm) |
| Custom split type | Always string | [Split a Field into Multiple Fields](https://help.tableau.com/current/pro/desktop/en-us/split.htm) |
| Split fields | Can't be join keys or pivoted; SQL Server allows four | [Split a Field into Multiple Fields](https://help.tableau.com/current/pro/desktop/en-us/split.htm) |
| Field in two folders | Not possible; duplicate the field | [Organize and Customize Fields in the Data Pane](https://help.tableau.com/current/pro/desktop/en-us/datafields_dwfeatures.htm) |
| Folder order | Alphabetical; a leading number forces order | [Organize and Customize Fields in the Data Pane](https://help.tableau.com/current/pro/desktop/en-us/datafields_dwfeatures.htm) |

## Check yourself

- Why might the Use Data Interpreter option be missing for a file?
- When do you write a SPLIT calculation instead of using the Split menu?
- Why can't a split field serve as a join key?

## Sources

- [Clean Data from Excel, CSV, PDF, and Google Sheets with Data Interpreter](https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm)
- [Pivot Data from Columns to Rows](https://help.tableau.com/current/pro/desktop/en-us/pivot.htm)
- [Split a Field into Multiple Fields](https://help.tableau.com/current/pro/desktop/en-us/split.htm)
- [Organize and Customize Fields in the Data Pane](https://help.tableau.com/current/pro/desktop/en-us/datafields_dwfeatures.htm)
- [Guide To Data Cleaning](https://www.tableau.com/learn/articles/what-is-data-cleaning)
- [Learn the Basics of Well-Structured Data](https://www.tableau.com/blog/learn-basics-well-structured-data)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 11 linked practice questions, and unlimited timed mock exams are included with the Tableau Data Analyst pack (USD $19): https://www.certifyforce.com/practice-exams