Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Does Dataiku offer handle input data of types XML (using XSD schema) and json?
Does it also handle the generation of output based on XSLT?
Or this should be done programmatically ?
Thank you in advance
Hi there,
DSS does indeed support using XML and JSON formats as input. More information can be found in our documentation here:
https://doc.dataiku.com/dss/latest/formats/xml.html
https://doc.dataiku.com/dss/latest/formats/json.html
In terms of your second question, it'd be helpful to get more context and details about your use case but yes you would likely need to do this programmatically. I hope that this helps!
Thanks,
Andrew
Thank you for your answer
I have checked the documentation when I tried to extract information during the upload of the xml, I couldn't get the information as shown in the example below:
let assume that I have this simple xml file:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<document>
<person gender="Male">
<lastName>Doe</LastName>
<firstName>John</firstName>
<phoneNumbers>
<phone type="fix">01 02 03 04 05</phone>
<phone type="Mobile">06 07 08 09 10</phone>
</phoneNumbers>
</person>
<person>..</person>
</document>
I want to extract each person with all its attributes as record using Xpath
gender | lastName | firstName | fix | mobile |
male | Doe | John | 01 02 03 04 05 | 06 07 08 09 10 |
when trying "XPaths to columns" in the schema/Preview it does not extract the expected information.
Thank you
I finally figure it out.
the issue was related to Xpath Expressions
just still have "xml_text": before each content
Thank you anyway
Hi there,
DSS does indeed support using XML and JSON formats as input. More information can be found in our documentation here:
https://doc.dataiku.com/dss/latest/formats/xml.html
https://doc.dataiku.com/dss/latest/formats/json.html
In terms of your second question, it'd be helpful to get more context and details about your use case but yes you would likely need to do this programmatically. I hope that this helps!
Thanks,
Andrew
Thank you for your answer
I have checked the documentation when I tried to extract information during the upload of the xml, I couldn't get the information as shown in the example below:
let assume that I have this simple xml file:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<document>
<person gender="Male">
<lastName>Doe</LastName>
<firstName>John</firstName>
<phoneNumbers>
<phone type="fix">01 02 03 04 05</phone>
<phone type="Mobile">06 07 08 09 10</phone>
</phoneNumbers>
</person>
<person>..</person>
</document>
I want to extract each person with all its attributes as record using Xpath
gender | lastName | firstName | fix | mobile |
male | Doe | John | 01 02 03 04 05 | 06 07 08 09 10 |
when trying "XPaths to columns" in the schema/Preview it does not extract the expected information.
Thank you
I finally figure it out.
the issue was related to Xpath Expressions
just still have "xml_text": before each content
Thank you anyway
Hi,
I also facing issue when uploading the excel file, its reading some columns.
But in those columns it looks nested array and contains xml_text before each content.
What will be solution and how you have resolved