topic Re: Full Outer Join in Talend Studio

Full Outer Join

Anonymous — Sat, 16 Nov 2024 14:22:47 GMT

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?

Re: Full Outer Join

Anonymous — Mon, 12 May 2008 06:41:16 GMT

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

shong

Re: Full Outer Join

Anonymous — Tue, 13 May 2008 11:48:44 GMT

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?

Re: Full Outer Join

Anonymous — Wed, 15 Apr 2009 22:17:13 GMT

I found this thread:
https://community.talend.com/t5/Design-and-Development/tJMSInput-configurations-for-IBM-MQ-messaging/td-p/110378