Max
2 years agoNew Contributor II
Data transformation issue
Hello,
I have a stored procedure that returns the following and i need that dataset transformed into the expected result. Thanks you for taking a look.
Stored procedure result/input:
[
{
"RiskLevelCode": "High",
"RiskLevelName": "High Risk",
"Low_Limit": 0.00,
"High_Limit": 75.00
},
{
"RiskLevelCode": "Med",
"RiskLevelName": "Medium Risk",
"Low_Limit": 75.10,
"High_Limit": 85.00
},
{
"RiskLevelCode": "Low",
"RiskLevelName": "Low Risk",
"Low_Limit": 85.10,
"High_Limit": 1000.00
}
]
Expected result:
"ranges":{
"highRiskLimitRange": "0-75",
"mediumRiskLimitRange": "75.10-85",
"lowRiskLimitRange": "85.10-1000"
}