Join 3 excels based on one common column values

Help
, , ,
1

Hello,
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.

2

Hi @7387023380
You want only the ID Column or even the rest of the column as well

Thanks
Ashwin S

3

all columns from 3 excels… and all matched and unmatched rows for all IDs

4

Hi @7387023380

@Palaniyappan help needed :slight_smile:

Thanks
Ashwin S

1 Like
5

@7387023380 I guess it’s better to provide the Excel Files and a Sample Output File, to Understand how do you want the Output to be :sweat_smile:

6

@supermanPunch
Consider these 2 input excels and 1 expected output file attaching here.

Expected.xlsx (8.4 KB) Input1.xlsx (8.3 KB) Input2.xlsx (14.0 KB) …

7

Kindly have a view on this and it might help you

@7387023380

8

@7387023380 Can you check this Workflow, This is not a general workflow, but it gave me the Expected Output :sweat_smile:, Check If this can work for the Real Scenario Join3Excels.zip (23.9 KB)