Need help


#1

For one of my other projects I need a piece of code which looks up data between two different DataTables:

First table has:
Request Number Status
123 Pending with XXXX
456 Completed
789 Completed

Second table has:
Request Number Status
123
999
342

At the end of execution, I need to resulting DataTable to look like this:
Request Number Status
123 Pending with XXXX
999 New Request
342 New Request


#2

Check out @Masire solution to RPA Challenge about a similar situation:

It should give you a good start.