Comparing Excel Document and after comparison would like to sort off results


#1

I’ve successfully compared two columns in my excel document. Now it did write the results as I requested. But now I need to take action off of the comparison. So off the Write Results document we added a new column called “Comparison” and I want to sort off of the Comparison column and the ones that say “No Match” I have additional steps to take. Can someone help me out?
Thanks!


#2

You can do this by looping through the dataTable that has been created.

For Each row in dataTable
if column(“Comparison”) = "No Match"
then Do Something…
Else
Next

Alternatively you can use dataTable.Select functions to select only those rows. Probably best searching the forum for examples first.