Merge 2 tables without primary key


#1

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)


#2

@Dominic @arivu96 @ovi


#3

Can you please check this How to merge two data tables


How do i merge two datatables which has 1 instance in 1 table and 3 instances in other data table
#4

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


#5

@ovi @Dominic @arivu96 any thoughts?


#6

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


Merge two datatables with common column
Compare rows from one excel to other excel
#7

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!!