Hi - I have two datatables I want to reconcile. However, I want 3 of the columns to match: Bank Name, Transaction ID, and Amount. I wanted to use AsEnumberable, which works for one column reconciliations - is there a way to have it review multiple columns?
bank_transactions.AsEnumerable().Any(Function(x) x(“Transaction ID”).ToString = transaction(1).ToString)
Could I do something like:
bank_transactions.AsEnumerable().Any(Function(x) x(Column A.ToString + Column B.ToString).ToString = transaction(1).ToString+transaction(2).ToString+transaction(3).ToString)
I’ve also tried to create a calculated field but didn’t have much success.