You are not logged in.
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?
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.
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.
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.