Merge Two Excel Files into one by using the first column as key

Like (1) Share

Report

Posted on 28 Sep 2024 05:52:25 by CU17092059-0

I have a flow which is getting different sets of data from two tables (which are stored into two different excel files) and I want
to merge the two into a single table by appending the data from the table in excel file 2 into the table into excel file 1. Both of
them have one common primary key which is unique (an e-mail adress).

I want combine both table into single table for each row return from the table in the second excel file, I tried with a for loop but could
not make it work.

Any solution on my problem here? Any help would be great.

All responses (1)

Answers (0)

Suggested answer

Nived_Nambiar 17,519 Super User 2025 Season 1 on 29 Sep 2024 at 05:04:19

Like (0)

Report

Merge Two Excel Files into one by using the first column as key

Hi,

May i know one thing here- like since it seems like join operation, what should we do for the rows in table1 which does not have same primary column value in table 2?- should we remove those rows ?

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!