PDA

View Full Version : Using Value Mapper for ranges



harley
11-27-2007, 08:08 AM
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