Overview
Rich Data Services provides the ability to recode data on the fly. There are two ways to do this, a simple recode, or a banded recode.
Simple Recode
While a simple recode may suffice in some circumstances, at other times users may like to recode a large group of values into smaller groups. The banded recode allows users to specify ranges of values to recode into new values.
Banded Recode
A banded recode provides a way of recoding multiple values at onece. In this case users will specify that a value range in the original variable should be recoded to a single value in the recoded variable.
Step By Step
Simple Recode
The syntax for a simple recode is newVar:originalVar[originalValue1=newValue1;originalValue2=newValue2;...]
Simple Recode{host}/rds/{collection}/{view}/select?cols=newVar:originalVar[0=1;1=2;2=3]
- The syntax for a banded recode is newVar:originalVar[start:end=newValue1;start:end=newValue2;...]. In addition, the value * can be used to specify a upper or lower limit.Banded Recode
{host}/rds/{collection}/{view}/select?cols=newVar:originalVar[*:10=1;11:20=2;21:*=3]