Column Menu Options for Quick Data Transformations

You can use the following column menu options to transform data in a data flow.

Option	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 data set.
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. CIC 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.