Hi,
I have been trying to do a datatable comparison to first check if the value of the cells in a column ‘ID’ match and if they do proceed to check if the cell value of the column ‘Name’ in one datatable is present in the other if not append a remark to a fresh datatable after which it checks for the cell value of the column ‘Amount’ credited if they are the same, less credited or over credited and also gives a remark in the new datatable.
So far i have been able to achieve ‘ID’ and ‘Amount’ comparison with this workflow Testuse.xaml (24.3 KB) but yet to achieve the name comparison with these data schedule received.xlsx (9.7 KB) Schedule Sent.xlsx (9.5 KB)
Here’s the new datatable format.
Thanks.