I have two Excel Sheets, in these two sheets I have one reference column and want to compare the row data based on reference column and get that entire row data in new sheet with both sheet columns.
And also in that new sheet want to add 02 new columns
Assuming that you are trying to join two excel sheets
In that case , Use Read rangefor 2 excel sheets
dt_1=sheet1
dt_2=sheet2
use join data table activity: input data table 1=dt_1
input data table 2=dt_2
final output:dt_final
Join type:Inner Join
Can you please mark the right post as solution such that it would help the community to access the answer easily
Also it will motivate the users to answer and help others just like @Brian_Mathew_Maben did to you