Hi. Is any using EasyMorph for data governance type rules? For example, we are looking for ways to normalize data with rules. For example, we may have the following values for the Technical Specification Name "Voltage":
10v
10 V
10 Volts
In this example, the acceptable value would be "10 V". If a new value is introduced, the data set, we would want to update to the acceptable value. Thanks.
Hello JWelch,
I think that you can achieve this in a smart way:
- Create a dictionary with two values: old string, new string. The dictionary could be an Excel file, a csv or whatever you want. In the dictionary you'll have:
| OLD string | NEW string |
|---|---|
| 10v | 10 V |
| 10 V | 10 V |
| 10 Volts | 10 V |
- In your EM project read the dictionary
- In the table that you need to normalize use the Lookup action, searching for OLD string values and return the new ones.
initial situation...
... and after the lookup
IMPORTANT: as you can see in the example there is a value "10 Volt" that is not changed because it doesn't have a corrispondence in the dictionary. In that case you need to insert the new record in the dictionary ("10 Volt" >> "10 V") and re-run the morph.
1 Like