Iterate through columns in a datatable

[prashant1603765 (Prashant Kumar)]

@manisha.k.chand

I want to iterate through a column values to check for same debit acc and if the debit acc is same I want to add the debit amount for all those rows
ex:

debit acc|debit amount
123 |500
456 |200
123 |300
123 |400
890 |200

I want the bot to iterate through debit acc column look for common values and sum those up.

Hi @manisha.k.chand

Use a For Each Row activity to iterate through the DataTable. Create a dictionary (debitSums). In the loop, check if the Debit Acc exists in the dictionary. If it does, add the Debit Amount to the sum, otherwise, add a new entry. After the loop, the dictionary will contain the summed amounts for each Debit Acc.

Happy Automation!