Transform Data in a Data Flow
You can use a data flow to transform data. For example, you might convert text to uppercase or trim leading and trailing spaces from data.
You can quickly transform the data in a column by using the
Options column menu in Data Preview. For example, you might
choose Convert to Number, Uppercase, or
Trim. The list of available menu options for a column depends
on the type of data in that column. Use transform options to:
- Update or modify the data in a column.
- Group or merge multiple columns in a data set.
- Add a column to or remove a column from a data set.
Use the Transform Column step in the data flow
editor.