Data actions for columns

Data actions for columns containing characters, dates, and/or numbers are listed on the Manipulation Tools panel. The actions that are available depend on the type of data in the column.

To show the data actions available for a column, select the gear icon next to the column name or right-click the name.
Table 1: Options on the DATA ACTIONS panel

Option

Description

Available from menu in column header

Available for

Characters

Dates

Numbers

Duplicate

Inserts a new column that is a copy of this column.

Yes

Yes

Yes

Yes

Rename

Changes the name of this column to a specified name.

Yes

Yes

Yes

Yes

Split

Divides this column after a specified split point and moves all string values after that point to a new column. The split can be a punctuation mark (for example, a comma) or a text string.

No

Yes

No

No

Remove

Removes this column.

Yes

Yes

Yes

Yes

Convert Case

Converts text in this column to lowercase or uppercase.

No

Yes

No

No

Replace

Finds a specified string in this column and replaces it with another specified string.

No

Yes

No

No

Fill

Prefixes or suffixes a specified string with a specified character, to a specified length.

No

Yes

No

No

Convert to Text

Converts all values in this column to text.

Yes

No

No

Yes

Convert to Number

Converts all values in this column to numbers.

Yes

Yes

No

No

Convert to Date

Converts all values in this column to dates in the selected format.

Yes

Yes

No

No

Trim

Removes characters in this column before or after a specified punctuation mark or character.

No

Yes

No

No

Group by Selection

Creates a group for the values selected in this column.

No

Yes

Yes

Yes

Group by Range

Creates a group for a specified range of values in this column.

No

Yes

Yes

Yes

Create Calculated Dimension

Creates a new column and applies a specified function to values in the new column.

For example, a "Floor" function can be applied to a "Margin" column to create a new column of margin values, rounded down to the nearest whole number.

No

No

Yes

Yes

Cell inner selection

In the Grid or Facets view:
  • Removes text in a specified word or range of characters in this column
  • Replaces text in a specified word or range of characters in this column
  • Creates a new column with data copied from this column and cleaned (for example, with "resort" removed from the data)
  • Moves specified text to the beginning of each row value in this column

No

Yes

No

No

Concatenate

Joins two or more columns, with an optional specified separator and name for the merged column.

Concatenate options become available when you select two or more columns.

No

No

No

No