Hi,I am facing trouble to parse JSON data into new table. I want to extract the fields and its corresponding value from JSON data.
Help me out
| Data |
PERIOD |
SEALID |
| {"SId":"420","applDetail":{"sName":"Sap","slob":"sCIB","caf":"sfalse","sGroup":null,"sprod":null},"smetrics":{"shfd":[{"numICADeploys":"0","numNonICADeploys":"10","totNumOfDeploys":"10","spercentageValue":"0"}],"sarc":[{"numAIMDeploys":"8","totNumOfDeploys":"10","spercentageValue":"80"}],"ssta":[{"numNIODeploys":"2","totNumOfDeploys":"10","spercentageValue":"20"}]}} |
2021-04 |
1,420.00000000000000 |
