Talend community forum / How to Map Data

Piero001 · 2012-05-23 14:47:10

Tags: [column, delimited file, mapping, schema, tJoin, tmap]

Hello Talend Community,

Think this is a noob queston, I'm sorry but I'm working for a job in which should two files be merged like shown in the screenshot.
I don't know how to do so. Do you know a tutorial for that? Should I use tMap or tJoin?

Regards,

Piero

Uploaded Images

thibault974 · 2012-05-23 15:13:05

Hi Piero001,

I think it will be easy for you to do this with tMap.

You can find some tutorials about how to set up a join link with tMap on http://www.talendforge.org/tutorials/menu.php

Hope it helps.

Regards,
Thibault

Piero001 · 2012-05-23 15:52:41

Hi Thibault

thank you for your answer.

I have tried the tutorial stuff. Connecting the columns seems no problem to me, but I think I have to change something in the tMap Settings ore give some Input to the expression Filter to generate the target output. As you can see in the screenshot, both source files have the same main column, but their input is not counted similar. The output file should has empty cells like in the screenshot is shown.

I couldn't find a tutorial for this specific so I started a topic it in the Forum.

Hope someone can help me to handle that.

Regards,

Piero

avdbrink · 2012-05-23 15:58:18

Hi Piero,

According to your input tables, it looks like you are trying to perform a FULL OUTER JOIN. Because there's ID values in table 1 that are not in table 2 and vice verse.

This is, as far as I know, not possible using just one tMap. You might consider reading both table twice, using one of them as lookup the first time and using the other one as lookup the second time.

Hope this helps.

Regards,
Arno

Piero001 · 2012-05-23 17:39:39

Hi Arno,

thank you again! I will try it out and give feedback soon.

Piero001 · 2012-05-25 17:03:15

Hi,

I used two tMaps (to produce an empty column) and a tUnite component. It works fine now!

Thank you all for your help

Regards,

Piero

Announcement

Unanswered posts

#1 2012-05-23 14:47:10

How to Map Data

#2 2012-05-23 15:13:05

Re: How to Map Data

#3 2012-05-23 15:52:41

Re: How to Map Data

#4 2012-05-23 15:58:18

Re: How to Map Data

#5 2012-05-23 17:39:39

Re: How to Map Data

#6 2012-05-25 17:03:15

Re: How to Map Data

Board footer