Full Outer Join

Highlighted
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?
Highlighted
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
Highlighted
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?
Highlighted
One Star

Re: Full Outer Join

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog