topic A need to unflatten xml in Talend Studio

A need to unflatten xml

Anonymous — Sat, 16 Nov 2024 07:37:40 GMT

I have the following challenge:

I have a webservice that returns the following inside a job

<response>
  <result>
    <title>something</title>
    <timestamp>sometimestamp</timestamp>
    <tag1>tag1value</tag1>
    <tag2>tag2value</tag2>
    <tag3>tag3value</tag3>
    <tag4>tag4value</tag4>
    ....
  </result>
</response>

And i need to change it to the following

<Report>
  <tagValues>
    <tagValue>
      <timestamp>sometimestamp</timestamp>
      <tagname>tag1</tagname>
      <value>tag1value</value>
    </tagValue>
    <tagValue>
      <timestamp>sometimestamp</timestamp>
      <tagname>tag2</tagname>
      <value>tag2value</value>
    </tagValue>
    <tagValue>
      <timestamp>sometimestamp</timestamp>
      <tagname>tag3</tagname>
      <value>tag3value</value>
    </tagValue>
    <tagValue>
      <timestamp>sometimestamp</timestamp>
      <tagname>tag4</tagname>
      <value>tag4value</value>
    </tagValue>
    ...
  </tagValues>
</report>

Is that at all possible?

Re: A need to unflatten xml

fdenis — Wed, 19 Sep 2018 10:00:11 GMT

you may use tXmlMap were you can define or modify schema of your xml.
when you have select tXmlMap Componet on your job you can press F1 to have help and samples

Re: A need to unflatten xml

DoDo69 — Wed, 19 Sep 2018 13:51:01 GMT

I don't know if it's easier to make a loop on each tag with the tXMLMap.

I think that the better way is to use XSL Transformation with a tXSLT component.

The content of the XSL file should be like this.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:template match="/">
     <Report>
        <tagValues>
           <xsl:for-each select="/response/result/**">
               <xsl:if test="name() != 'title' and name() != 'timestamp'">
                  <tagValue>
                      <timestamp><xsl:value-of select="/response/result/timestamp"/></timestamp>
                      <tagname><xsl:value-of select="name()"/></tagname>
                      <value><xsl:value-of select="."/></value>
                  </tagValue>
               </xsl:if>
           </xsl:for-each>
        </tagValues>
     </Report>
  </xsl:template>
</xsl:stylesheet>

Re: A need to unflatten xml

Anonymous — Thu, 20 Sep 2018 08:47:05 GMT

The XSLT sounds good.

Is there a way to apply XSLT in Talend without going through the tXSLT component (and it's need for files) for instance in a tJavaRow?

Re: A need to unflatten xml

fdenis — Thu, 20 Sep 2018 08:54:11 GMT

you can use javax.xml to do it on tJavarow or tjava or tJavaFlex
but think about person who is going to reopen your job.
with tjavaxxx he have to read your code
with tXLST he know that it's xml transformer

Re: A need to unflatten xml

DoDo69 — Thu, 20 Sep 2018 08:56:53 GMT

Yes it should be possible to do this in java in tJavaRow.

I think you can adapt the code present in the following link : https://gist.github.com/serge1/9307868

You just need to generate a source with a String, but I think it's possible.

To me, the code is very easy to understand, so I think it's not a bad way to use a tJavaRow if you don't want to write your XML in a file.