Mapping enumerated values in a DSQL map
Map enumerated values from an input structure to different enumerated values in
an output structure.
Before you begin
About this task
Procedure
Results
A SWITCH clause is automatically created in the expression editor
for the status element:
SWITCH (tier) {
CASE 'One' : 'Platinum'
CASE 'Two' : 'Gold'
CASE 'Three' : 'Silver'
}The map is configured, you can click Test Run to see the
result. In this example, this is the output:
{
"customers":[
{
"id":"abc-123",
"name":"John Doe",
"status":"Gold"
},
{
"id":"def-456",
"name":"Jane Smith",
"status":"Platinum"
},
{
"id":"ghi-789",
"name":"Emily Stone",
"status":"Silver"
}
]
}