I have a scenario where I'm collating data from multiple sources, so I'm evaluating the Kettle app to see if it will be helpful in bringing the data into a common format.

I have experimented with the value mapper and it is very intuitive. However, I have one question I cannot resolve.

In a simple scenario, I have two tables that house information related to bleeding during surgery. One center transfers mild moderate and severe, another transfers volumes in mls. How can I map the volume units into a mild, moderate, severe format.

For example
100-300 = mild
301-600 = moderate
601 + = severe

Thanks in advance