This template will allow you to create your own normalator based on a new set of categories and rules. There are no pre-existing rules.
Create a test data set to help you create your rules; for example using a spreadsheet. Ensure you have the following columns in your spreadsheet:
- Source Column or Free Text – the one you want to normalate.
- Target Column or Category field – the target field
- Reference Column ID field – a unique reference for each row in your spreadsheet
Create a new normalator and choose the Blank template.
Use the Normalator screen to highlight the key words or phrases and create your categories.