Tableau - Fields Operations


Advertisements


Tableau has many features to manipulate the fields present in Tableau data pane. You can rename the fields or combine two fields to create one field. Such operations help in better organization of the dimensions and measures, as well as accommodate two or more fields with the same name for better data analysis.

Following are the important examples of such Field Operations.

Adding Fields to Worksheet

You can add any field to the worksheet by right-clicking and choosing the option Add to Sheet. You can also drag and drop the fields into different shelves present in the worksheet, like Columns shelf, Rows shelf, Filters shelf, and many other shelves under the Marks card. The following diagram shows the right-click option.

Field operation 1

Combining Two Fields

You can combine two dimension fields to create one field. This combined field has a name which is a combination of the individual fields. The values in the dimension get combined to a single value by joining the two strings into one string separated by a comma. However, this default name can be changed by using the rename field operation. The following diagram shows the step to combine two fields.

Field operation 2

Searching Fields

You can search for names of fields by using the search box option. Writing first three or more letters of the field name brings out the result showing only the fields whose name contains these letters.

Field operation 3

Reordering Fields

You can change the position of fields by simply dragging them up and down. In the following example, we drag the field customer name to the place between state and city. This is usually done to bring similar fields together which are frequently used for analysis.

Field operation 4

Advertisements