Hi,
I have an XML field in my view and I have different problems to manipulate it in Denodo.
First onne, I want to use the function xmlquery to get a specific list of element in my XML.
for example, I have this xml :
<?xml version='1.0'
encoding='UTF-8'?>
<shop>
<products>
<product>
<id>1</id>
<name>Virtual DataPort</name>
</product>
<product>
<id>2</id>
<name>ITPilot</name>
</product>
<product>
<id>3</id>
<name>Scheduler</name>
</product>
</products>
</shop>
I want to get all the products but each product must be in a specific line, I dont want to get the result of the 3 products in the same line in denodo View. Is this possible?
I also want to use some function like CREATETYPEFROMXML, but it's said in the documentation :
The function CREATETYPEFROMXML is deprecated and may be removed in future versions of the Denodo Platform. Instead, create an XML data source with a route of type from variable and pass the XML document to this data source ==> so how can I transform an XML field in my view into a register object or array and manipulated more easily, or maybe create some base views using this field?
As I said, I dont have an XML file as data source but rather an XML field comming from a mongodb Database as text and then I transform it to xml.
Thank you,
