Transforms - Replacement Rules

Usage

The Replacement Rule feature allows you to replace certain characters during your data transfer. 

You may have a column that contains data you want to remove or hide before transferring to your destination. You can define a replacement rule for that column, and replace all values before loading them into your target destination.

• Replacement Rules is specific to a pipeline and needs 4 things

  • Collection/Table - e.g. Test.Employees (source/db.table_name)

  • Column - e.g. Name

  • Find (Regex) - ^\w+

  • Replace (String) - `***`

• So How are you? → *** are you?