One Star

Full Outer Join

I'm performing transforms on some CSV files. I'd like to perform a Full Outer Join between two files but without involving a database. I think this should be possible throuhg either a Map with 'All Matches' and inner join not checked, or with tJoin again with inner join not checked.
Can anyone help?
3 REPLIES
Community Manager

Re: Full Outer Join

Hello
yes, you can do full left outer join on tMap, please see this 1659.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Full Outer Join

Hi there, thanks for your comments,
I'm putting together a timeline of 2 diffferent types of events. The different types of events don't necessarily happen on the same day. If I do a left or right I will exclude those events from the result set from the dominant side that do not match the passive side. I need to do specifically the 'full outer join' to bring both sides into the result set and join for those occaisions when they do happen on the same day.
I could build up a timeline of points left join onto both event type sources but that means creating too many rows in the main table, a 'full outer' would be more efficient.
Has Talend got it?
One Star

Re: Full Outer Join