I want to compare debit acc and credit columns to check if any debit acc is getting credited first

Help Studio
, ,
1

Hi, I want the bot to iterate through the debit accounts and check if any debit acc is getting credited in the credit columnn…if so then that transaction will take place first..I just want a logic I can apply

ex
debit acc|debit amount|Credit acc
123 |500 |456
456 |200 |345
345|300 |444

Forum Engagement Daily Reports
2

Hi @manisha.k.chand

Can you try this

DebitAcc = CurrentRow("Debit Acc").ToString

If : dt.AsEnumerable.Any(Function(x) x("Credit Acc").ToString.Equals(DebitAcc))

A workflow diagram depicting reading data from an Excel file, processing each row to check a condition, and logging messages accordingly. (Captioned by AI)
A workflow diagram depicting reading data from an Excel file, processing each row to check a condition, and logging messages accordingly. (Captioned by AI)634×1080 42.3 KB

Input:

A spreadsheet displaying debit account numbers, debit amounts, and corresponding credit account numbers. (Captioned by AI)
A spreadsheet displaying debit account numbers, debit amounts, and corresponding credit account numbers. (Captioned by AI)715×408 6.28 KB

Output:

The output window of an RPA tool displays log details of an execution, highlighting the results of three matches, with two matches successful and one unsuccessful. (Captioned by AI)
The output window of an RPA tool displays log details of an execution, highlighting the results of three matches, with two matches successful and one unsuccessful. (Captioned by AI)783×430 15.3 KB

Regards,

3

Hi it works for checking if the debit account is matching the credit acc in other column but what if I want to print out the other values of the same credit row that has matched with the debit acc.

4

@manisha.k.chand
some details are maybe more to clear

However, we recommend getting familiar with data joins

and depending on the use case details maybe setting up

  • lookups
  • transcedence chains, self joins

can help.