topic Re: mapping 2 separate input fields to one field in data mapper in Talend Studio

mapping 2 separate input fields to one field in data mapper

Anonymous — Mon, 28 May 2018 14:34:48 GMT

I am completely new to Talend, so please bear with me

I have a simple input file in with 2 separate fields that should be mapped to the same field in the xsd. I am trying to achieve this using data mapper.

This drawing illustrates what I am trying to achieve:

Since talend does not allow me to drag n drop to the same field I guess this requires some sort of looping, but I am yet to find out how to do this.

Could you please provide me with some guidance on how exactly to do this?

Thanks in advance

Re: mapping 2 separate input fields to one field in data mapper

manodwhb — Tue, 29 May 2018 10:16:14 GMT

@Wookie,in tmap you can concantenate.

row1.field+" "+row2.field

Re: mapping 2 separate input fields to one field in data mapper

Anonymous — Tue, 29 May 2018 12:01:33 GMT

Thanks for the suggestion, but I cannot imagine that will help since I am not trying to merge the fields by rather repeat/loop them. Let me clarify:

if you take a look at the output schema the field I am trying to map to is nested. It looks like this (simplified)

<organisationAssociations>
<organisation>
<v3:source_id>ENTRIES FROM ORG</v3:source_id>
</organisation>
</staffOrganisationAssociation>

What I am trying to do is get this:

Is that possible?