Cleanse

Documentation

Cleanse

Examples

Clean a text column

Perform a text replacement in the TrueOrFalse column of the source data.

1. Add the TrueOrFalse column to Text Columns to Cleanse.
2. Create two new Regular Expressions by clicking Add RegEx twice.
3. In the first RegEx, set the Search for Regex input to True, and set Replace With with Yes.
4. In the second RegEx, set the Search for Regex input to False, and set Replace With with No.

The node is now ready to be connected to another node.