Add data to datatable after each transaction, and export to output spreadsheet

Help Studio
, ,
1

Hello Community,

I have a scenario I need to build out but am having trouble getting there:

Scenario: The automation will be given an input excel file which will contain each transaction. The bot processes each transaction in which it will get multiple datapoints during the process. After all transactions are completed, the results are to be put into an output excel file.

What I want to do: I want to build a datatable that will have the data points of each transaction saved to its own row, so that when its get to end process, the Datatable can be easily appended to the outlook excel file. How can I do this? I know I need to use Build Datatable activity during initialization, but how do I add data to the table for each transaction?

2

Try adding to the output data table using add data row at the end of for each and when all the transactions are finished you can write that to an excel at the end state.

Thanks