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?
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?