What is Raw to Clean Mapping?

Raw to Clean Mapping allows you to create a rule that will do a mass find and replace when data is inserted into a table inside Foundation. This can be used to normalize entries that may be coming from different sources.

1. From the Flow tool click the '+' symbol beside Raw to Clean Mapping.

2. Fill out the information for the mapping.

  1. Name - What name you would like the mapping to have.
  2. Tables - What tables you want this mapping to be on. You can select as many tables as needed.
  3. Raw - This is the value you are looking to replace.
  4. Clean - This is the value you want to replace with.
  5. Case Sensitive - Choose whether the raw should be case sensitive or not.


4. Save your mapping.

5. Congratulations, you have created a Raw to Clean Mapping!