Compare Two Data Tables based on Two Columns

Learn Certification
, ,
1

I am using a For Each Row loop to cycle through the rows of my source table then another For Each loop to cycle through the rows of my target table. I am currently only able to compare one column with another. I need advice on how to compare two columns that make up a primary key (unique).

If condition:

row.item(2).ToString = line.item(2).ToString

Thanks.

2

Hi @tolenal

Hi can u share the sample excel file and scenario

Regards

Nived N