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]
Asked
Active
Viewed 362 times
0
-
Please show us some code of what you have tried so far and provide some example data. – mbuechmann Sep 26 '18 at 14:50
1 Answers
1
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.
Dolfa
- 796
- 4
- 21