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 :
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.