Read 2 columns from different excels, if matches keep entire row ,if not matches delete entire row

Hello All,

I’m Reading 2 excels 8am.xlsx & 8pm.xlsx with the same column names. I need to compare the column"URN"(Col index 6) from 8pm.xlsx in 8am.xlsx. if matches keep the row , if do not match delete the entire row in 8am.xlsx.

Please Suggest me the solution. Thank you.

Hi @Nagabhushan_I_S, welcome to forum
you can refer the link of how to use matched rows and unmatched rows from datatable by using linq query

Hope it help you
Mark it as solution if you got it

Nived N
Happy Automation


Welcome to Forums

Check below for your reference

Hope this helps you