Compare rows from one excel to other excel

[avinashy (Avinash)]

Hi,

I have 2 excels .

First excel have 2 columns with Name and City.
Second Excel have 2 columns Name and Age.

Now i want to pick Name from first excel and have to search in excel 2,if name matches i want to read the corresponding Age from excel 2 and store it in another excel.

kindly help on it.

Thanks

[arivu96 (Arivazhagan A)]

Hi @avinashy,
Refer this post,

Merge 2 tables without primary key

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

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

(Join Two Data table)

Regards,
Arivu