How do I extract JSON values along with keys using Xpath in Clover ETL{"code": "in","percent": 83}? Eg :-. For the JSON object in the example I don't want just values i.e [in,83] I also want keys with them i.e ["code": in,"percent": 83]
{"code": "in","percent": 83}
["code": in,"percent": 83]
You are looking for "decode(name())" function of XPath.
There is an example in the documentation https://doc.cloverdx.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/jsonreader.html (search "name()") which is doing what you need.
You are looking for "decode(name())" function of XPath.
There is an example in the documentation https://doc.cloverdx.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/jsonreader.html (search "name()") which is doing what you need.