topic Re: tWriteXMLField : How to use it ? in Talend Studio

tWriteXMLField : How to use it ?

_AnonymousUser — Sat, 16 Nov 2024 13:58:11 GMT

Hi,
Where can I find some documentation about that component ?
There's none in the Reference Guide.
Taking datas from a delimited file, I need to load a table which has XML fields.
I think the tWriteXMLField is the key.
But in that component output, I only manage to have a lonely XML field. (which is already a good thing)
How should I do to get that XML field along with the others normal fields in the same link ?
Thank you,
Nicolas

Re: tWriteXMLField : How to use it ?

Anonymous — Thu, 07 May 2009 07:08:25 GMT

Hello
tWriteXMLField is be used to create a xml structure field with rows. H ere is a use case, please see my screenshots.
Best regards

shong

Re: tWriteXMLField : How to use it ?

_AnonymousUser — Mon, 11 May 2009 08:44:21 GMT

Thank you for that use case Shong,
After a few tries, I think I don't need to use the group by option.
I want to use this component only to facilitate the development of my jobs (it's easier to generate the XML structure from the name of the fields than concatenate the strings with the tags).
I managed to create the XML field, as in your example, but I don't know how to integrate that field into the table ?
In the output of my job, I would like to have the whole structure of my table containing the WML field, and not only the XML field.
Thanks for your help,
Regards,
Nicolas

Re: tWriteXMLField : How to use it ?

_AnonymousUser — Wed, 08 Jun 2011 18:22:59 GMT

I am encountering the same issue. Any work-arounds?

Re: tWriteXMLField : How to use it ?

Anonymous — Thu, 09 Jun 2011 05:15:33 GMT

Hi all
I have missed this topic, What's the schema of table?
Best regards
Shong

Re: tWriteXMLField : How to use it ?

Anonymous — Fri, 23 Sep 2011 14:42:45 GMT

Shong, The root of the problem is that the tWriteXMLField component only allows one output column, the XML. All the other data in the schema up to that point is lost.

Re: tWriteXMLField : How to use it ?

Anonymous — Thu, 05 Nov 2015 09:11:16 GMT

Is the support for the free users of TOS is deliberatly uncomplete, or may we can find the answer underline by the question of these 3 users somewhere?
edit: here is an exemple of the problem describe:
farmtest is the column where the xml generated with the input column is formed ; it's OK, and well generated.
BUT, I also want to retrieve, 2 originals columns in my output link, here id & n
THE PROBLEM is that my 2 outputs columns id & n are EMPTY
any suggestion?

Re: tWriteXMLField : How to use it ?

_AnonymousUser — Thu, 04 Feb 2016 17:57:16 GMT

Hello,
I encounter exactly the same issue as rsouris, any workaround to propose ?
Could you please help ?
Thanks