Column Menu Options for Quick Data Transformations
In the transform editor, column options enable you to quickly transform your data. For example, to categorize racing lap times in a dataset column, you might right-click the 'Lap Time' column and select Bin.
Options | Description |
---|---|
Bin | Create your custom groups for number ranges. |
Convert to Number | Change the data type of the column to number and delete any values that aren't numbers. |
Convert to Text | Change the data type of a column to text. |
Delete | Select and remove a column from the dataset. |
Duplicate | Create a column with data that’s identical to the selected column. |
Group | Create a custom group to combine related values. For example, you can group states with custom regions and categorize dollar amounts into groups showing small, medium, and large. |
Lowercase | Convert all the text in the column to lowercase. |
Merge Columns | Combine two or more columns to display as one. |
Rename | Change the column name. |
Sentence Case | Convert the first letter of the first word to uppercase on each row in a column. |
Transform | Modify the column data by using an expression. |
Trim | Remove leading and trailing spaces from text data. Oracle Analytics doesn't show leading or trailing spaces in the data preview, but if the original data source contained leading or trailing spaces, this can affect queries. |
Uppercase | Convert all the text in the column to uppercase. |