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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download