PRODUCT
INTEGRATIONS
SOLUTIONS
LEARN
COMPANY
Ignite Discussions : Ask Questions, Find Answers, Share Expertise about Sparkflows
How to handle this?
Hey Chris,
In Sparkflows, we can use the ‘Remove Unwanted Characters’ processor to remove spaces in data.
To use the ‘Remove Unwanted Characters’ Processor:
- Select one or multiple columns in the ‘Input Columns’ list. Data in these selected columns would be transformed.
- Select ‘Remove Whitespaces’ field as ‘True’. White space from the data would be removed. Later on data can be casted to Numeric based on the need.
For more information read the Sparkflows Documentation here:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/data-cleaning.html?highlight=remove%20unwanted%20characters#remove-unwanted-characters
Hey Chris,
In Sparkflows, we can use the ‘Remove Unwanted Characters’ processor to remove spaces in data.
To use the ‘Remove Unwanted Characters’ Processor:
- Select one or multiple columns in the ‘Input Columns’ list. Data in these selected columns would be transformed.
- Select ‘Remove Whitespaces’ field as ‘True’. White space from the data would be removed. Later on data can be casted to Numeric based on the need.
For more information read the Sparkflows Documentation here:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/data-cleaning.html?highlight=remove%20unwanted%20characters#remove-unwanted-characters