Merge 2 tables without primary key

I have two tables which doesn’t have a primary key. I want to merge them. I have attached a sample worksheet below.merge multiple.xlsx (10.1 KB)

@Dominic @arivu96 @ovi

Can you please check this How to merge two data tables

but that doesnt solve the problem when the order is different.

@ovi @Dominic @arivu96 any thoughts?

Hi ,
Here I have attached a sample for merge 2 tables without primarykey. I have written the output in Sheet4

file : SampleMergeDatatable.zip (11.4 KB)

Thank you
Balamurugan.S

2 Likes

Hi, I’m trying to change your code a little to fit my use, but I don’t quite understand your code used in the invoke code activity. Could you please explain more about it? Thanks a ton!!