I have two excel’ s need to compare both need remove the not matching row columns .I had tried UiPath activities but it doesn’t help me much because data tables contains with 100 thousand rows,
There is any alternate solution Please help me .
In my cases there different column Name in datatable(DT1) need to compare with other data table column in dt2 with different column .
We need to compare the both the datatables if any of the row column is matched we need to remove and non matched row column data need to store in other data table.
But data is more than 7 to 10 Lakhs records.