If needed, you can clean the names of the columns in your dataset. When column names are sanitized:
_) are permitted
Although supports a wider range of characters, you may wish to sanitize your column names to simplify publishing to and import into downstream systems.
Tip: Sanitized names matches the column names supported in Release 5.0 and earlier.
The above sanitization can be applied to your column names when the dataset is imported.
Tip: If you notice issues with references to your column names in your recipes, you may be able to fix them by re-importing the dataset and choosing to sanitize during import.
For more information, see Import Data Page.
Through the Transform Builder, you can add a step to sanitize column names in your recipe.
Tip: If you are sanitizing your column names for downstream systems, you should add this step at the end of your recipe.
You can perform more fine-grained column renaming operations. See Rename Columns.