Compare data table and add datatable column

Hey everyone! Really quick I have a datatable, ExcelSheet1, that I want to add a data column of Status. I want to compare this datatable with another datatable, RejTable, to see if they have the same values. Under certain conditions, I need to update the status column accordingly. For example: If the amount is on the rejTable and the account number column is the same, check to see account number is the same, if account number same check for product code column, if these are the same, Write ALS exception, else write exception in status column. I was getting something about an invocation error. Any help is appreciated.


Hi @mlmyers,
You need to keep the data in separate DataTables and compare each cell one by one. Here you have simple example how you could compare the data. (7.9 KB)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.