How to compare two data tables and if they have matches combine them into one data table

Help Studio
1

I have two data tables DT1 and DT2, and I want to compare the first column**(Document and Invoice No)** of both data tables if any row matches then I want to combine that row from both columns and then store it in another data table
My first Data table
DT1
My second data table
DT2

As both DT1 and DT2 have (ISI-22031592)
So my output data table should be like this
image

2

Hi @Sami_Rajput ,

Have you tried using Join Datatables Activity with Inner Join as the Join Type?

It does seem to match your case / expected output.

Let us know if it does not work with that activity and provide us what was the issue experienced with it.