Hi Team,
I am processing the transaction in RE- DataTable.
I want to update the each transaction status in same sheet as failed or success even also retry count
in their respective row of input excel
So suggest tme how Can I implement this?
Thanks in advance!!!
You can rely on TransactionNumber. It initializes with 1 so in your Main.xaml ->Process Transaction state → Try Catch Finally section you can add your Write Cell activity to write the status like this "Z"+TransactionNumber+1
Hey @Sanket_Shinde1,
Use Add Data Column in input DataTable for Status and RetryCount, update values after each transaction using row index, finally write updated DataTable back to same Excel sheet.
okay if bot process 5 record out of 10 - gor stop
when re run 6 record will start to process but transacion number is 1 again
in input sheet already has colunm retry and status
But how i can write that specific row - update.
even if bot rerun so it will need to update that processed row only
if rely on transaction number whenever rerun the bot it get initialized to 1
That’s right. To avoid this, instead of starting from the failed row, let the execution start from the first row but before start processing the transaction, add a if activity to check if the Status column is empty. If empty then only process the transaction else continue to next transaction.
it will be done it initialization,
So when goes to process then transaction number will be 1 by default
Record will failed or not processed yet -
But question is how to update that specific row
Even re run the bot
Bot start processing 6 row of input excel so it should update that row 6th only as success or failed
Use a unique ID for each transaction (TransactionID column in Excel).
Before processing, check if the row was already processed (Status = Success).
After each transaction, update the Status and Retry in the DataTable.
Write back the DataTable to Excel after each transaction so reruns pick up from the next unprocessed row.
This way, even if TransactionNumber starts from 1 again, the bot skips already processed items.
Without adding the transactionID column any other approach,
there might be chances that business team add mismatch column numbers
If you are using RE framework , add a column “Status” to the DT if it is not present and then
In set transaction status System exception and Buisness exception workflow assign transactionItem(“Status”) = “Failed”
In success workflow assign transactionItem(“Status”) = “Success”
and write back dt_transactionData back to the excel in the end process
Add a condition get transaction data to check if transactionItem is empty or “Failed” Skip the transaction and check with the next one
Hope this helps!
There is but would be complicated a bit.
Like create a final folder for the Excel and remove the column before moving to the final folder
Here is how to handle this. Customize it as per requirement.
CustomREFramework.zip (1.3 MB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.