Excel Based REFramework - Handling Exception

Help Studio
, , ,
1

Hello!

I’m currently automating a process with the REFramework, where I have an Excel database with the IDs of some vendors (read range in Initialization), and I must retrieve their basic information in a system. After I retrieve their information, I have to create those vendors in another system.

The catch is, from that one vendor ID, there could be more than one vendor created based on how many bank accounts it has. To do that, I manipulate the information and save the new vendor IDs in a datatable. From there, I create the vendors based on the datatable that is in my Process file.

How do I handle exceptions when it is creating the vendors, so that when I throw and try catch, it will continue to the next row in datatable? At the moment I am assuming that it will continue to the next item in my Excel instead of the next item in my datatable?

2

@farhana.zainal

What would be the next item will be controlled by how you are getting the data in get transaction data…if you read the data from excel for the firsttime and from then on using datatable to get the data then yes data will be picked from datatable

If not if getting data based on transactionnumber from excel then excel is where it would pick

Cheers