Hello,
I have a requirement where I have to read XML's using the xpath meta data, is there any way in Alteryx by which I do ?
XML Example :
<Names>
<Name>
<Student-Name>Anything</Student-Name>
<RollNo>1234</RollNo>
</Name>
</Names>
xpath : "Names/Name/Student-Name" should return me "Anything"
JSON Example:
{
"Name": {
"Student-Name": "Anything",
"RollNo": 1234
}
}
xpath : "Name.Student-Name" should return me "Anything"
Solved! Go to Solution.
You can use the XML parse/JSON parse to do that. I personally think that the JSON is a better choice to work with Alteryx.
Hi @felipe_Ribeir0
Thanks for the solution but I want to the xpath as an input to get that particular node data or tag data.
You wont have exactly the xpath here without using some programming language, but by parsing the JSON and filtering Student-Name you will get what you need, right?