Normalize Columns
Description
This activity normalizes column values based on the selected transformation methods. The user can specify different normalization techniques to clean and standardize data.
Input
Data
Output
Transformed Data
Configuration Fields
-
Column Map Set of column names and the corresponding normalization methods to apply.
Normalization Options Include
- Convert to lowercase
- Convert to uppercase
- Convert to title case
- Capitalize first letter
- Trim whitespace
- Remove special characters
- Remove whitespace
- Normalize accents
-
Include Original If enabled, keeps the input columns along with the transformed columns. If disabled, only transformed columns are included in the output.
Sample Input
| ID | Name | Description | Category |
|---|---|---|---|
| 1 | jOHN DOE | Software Engineer | IT & Tech |
| 2 | jane SMITH | Data Scientist | Analytics |
| 3 | mark_o’leary | Machine Learning | AI & ML |
Sample Configuration
Sample Output
| ID | Name | Description | Category |
|---|---|---|---|
| 1 | John Doe | SOFTWARE ENGINEER | IT Tech |
| 2 | Jane Smith | DATA SCIENTIST | Analytics |
| 3 | Mark O’Leary | MACHINE LEARNING | AI ML |