I have two datatable. One is the history data table and the other is a datatable that the robot create run-time.
I need to check if in the data table that the robot create runtime there is a match in with the history file and delete all the matches row in the data table that the robot create runtime.
I’ve already tried using For Each and a filter data table but I no want to iterate the History data table for speed reasons.
This is the historical file
This is the run-time file
I need something that don’t iterate the historical file but give me as a result all the rows that are not matched in the history file