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.
|
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:
|
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 |