I want to join 3 excels column wise. 3 input excels contains multiple columns and only one “ID” column common. I want to join excel with all matched and unmatched values from ID column.
Unmatched ID values may have empty rows.SO in short I want to do outer join.
Join activity.merge activity does not help here.
Thanks in advance.