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

Help Activities
1

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.

2

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

3

@Nagabhushan_I_S

Welcome to Forums

Check below for your reference
https://forum.uipath.com/t/tutorial-how-to-check-a-string-is-present-in-excel-sheet-part-1/243696/2

Hope this helps you

Thanks