The Mass Transform is one of several bulk operations available in Cleanse (Brushr). Users can create transformation rules and then execute them en mass using this option.
- Start by selecting the Mass Transform option.
- In the Transform Actions dialogue window, users can toggle whether a field transformation should be included on the Mass Transform action.
Transform Rules are associated to the corresponding fields via the Dataset Configuration menu by selecting 3 Dots > Edit Dataset > Transform > Pencil Icon. You can also use the AI Assistant to generate transform rules from natural language prompts.
- In the Transform Preview dialogue window, you can filter records to select records to be "transformed" based on computed Data Quality Model and Validity scores. Transform rules also support contains and equals operations with regular expressions (regex) for advanced logic.
- Once you made your selections, press the Transform All button.
- Press the Confirm button to run the rules.
