tWriteXMLField : How to use it ?

Not applicable

tWriteXMLField : How to use it ?

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
Community Manager

Re: tWriteXMLField : How to use it ?

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Not applicable

Re: tWriteXMLField : How to use it ?

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
One Star

Re: tWriteXMLField : How to use it ?

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

Re: tWriteXMLField : How to use it ?

Hi all
I have missed this topic, What's the schema of table?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tWriteXMLField : How to use it ?

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.
One Star

Re: tWriteXMLField : How to use it ?

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?
One Star

Re: tWriteXMLField : How to use it ?

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