Help map fields and full XML to output columns

[Anonymous]

Hello all,

I am in need of some assistance. I am trying to take a full XML, map a few fields to columns, and also map the full XML to the final column in the output. I am very new to Talend and data mapping in general. I have tried to use the THMap component as that is what I am most familiar with, but have not been able to get the full XML over to a single column. Is this possible with another component? I am unfamiliar with most other Talend components. 

Please let me know if there is more info I can provide.

Sample Input:

<start>

     <team>

          <teamId>id1</teamId>

          <person>

               <name>johndoe</name>

               <address>123 main st</address>

          </person>

          <person>

               <name>janedoe</name>

               <address>321 west main st</address>

          </person>

     </team>

</start>

desired output:

teamId    |    countOfPerson    |     fullXML

    id1      |           2                   |     <start></start>

[vapukov]

hi,

could you little explain - what input format(source), what transformation, what expected output format (little more).

it definitely possible (at least in my jobs, and hope in your as well 🙂 ) - but need more detail for advice much close to a real job