topic Re: [tFileoutputXML] Delete the "row tag" in Talend Studio

[tFileoutputXML] Delete the "row tag"

Anonymous — Sat, 16 Nov 2024 13:54:15 GMT

Hi all,
When I generate an XML File, there automatically is the "row tag". Idon't want it to be included. I haven't seen any option that permits that.
How to manage that?
For example, in this XML File, the "row tag" is useless. nevertheless, it"s automatically included.

<?xml version="1.0" encoding="ISO-8859-15"?>
<N_PERIOD>
  <row>
    <YEAR_DF>1985</YEAR_DF>
  </row>
  <row>
    <YEAR_DF>1986</YEAR_DF>
  </row>
  <row>
    <YEAR_DF>1987</YEAR_DF>
  </row>
  <row>
    <YEAR_DF>1988</YEAR_DF>
  </row>
</N_PERIOD>

Thanks!
mathieu

Re: [tFileoutputXML] Delete the "row tag"

Anonymous — Tue, 23 Jun 2009 11:22:50 GMT

hi,
when you write into a output xml file you may specify the name of Document element (root) in the 'row tag' ...
ok ! a little screen shoot for an SVG document for example
++
laurent

Re: [tFileoutputXML] Delete the "row tag"

Anonymous — Tue, 23 Jun 2009 12:08:32 GMT

hello,
Thanks for your answer
I put "N_PERIOD" as "row tag", which is also the root tag of my XML but it didn't work.
Could you tell me which "row tag" I have to put, in my case
Thanks!
Mat'

Re: [tFileoutputXML] Delete the "row tag"

Anonymous — Tue, 23 Jun 2009 12:37:10 GMT

sorry ,
i've made a mistake :it's specified the name of the row (element) an wrap each row into this element ...
still have root document name = "row" at least
i've answer a little bit too fast ...
did you try with new component 3.1 like twritexmlfield !?
edit : have a look at https://community.talend.com/t5/Design-and-Development/tWriteXMLField-How-to-use-it/td-p/99251 ...
I have learn something more today

Re: [tFileoutputXML] Delete the "row tag"

Anonymous — Tue, 23 Jun 2009 15:53:32 GMT

Hello mathieu_r
When you output xml file, there must exist a loop element. Here, row tag is the loop element. So, we can't ignore it on output component.
Well, you can write some Java code to delete row tag after you output the xml file.
Best regards
shong

Re: [tFileoutputXML] Delete the "row tag"

Anonymous — Tue, 23 Jun 2009 16:36:30 GMT

Ok thanks for your answer

Re: [tFileoutputXML] Delete the "row tag"

Anonymous — Tue, 23 Jun 2009 18:05:00 GMT

I would advise to use xslt to structure the output xml as you need to.
But it's true, the first time, xsl-t doesn't seems easy. But manipulating hierarchical data is quite different to tabular, so it needs a different approach.