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 Minitab Connect). This can be used to "normalize" entries that come from different sources.

1. Open the Flow Tool, then click the Input(s) tab.

2. Click the (+) Add symbol (beside Raw to Clean Mapping).

3. Fill out the Info for the mapping:

      Name - What name you would like the mapping to have.

      Tables - What tables you want this mapping to be on. You can select as many tables as needed.

      Raw - This is the value you are looking to replace.

      Clean - This is the value you want to replace with.

      Case Sensitive - Choose whether the raw should be case sensitive or not.

4. Click the Save icon.

Congratulations, you have created a Raw to Clean Mapping!