I have a For Each Row Activity, in that activity i have a datatable as an input. The datatable contains a column and in every row there is a specific name.
I then do a specific action using each of the names for every row.
For each name I download a new excel file. I then use a Read Range activity and filter the Excel file with the “Filter Data Table” activity. Based on two columns and the rows that they contain i make a calculation. The result of the calculation I want to add to a new datatable along with the name.
I cant figure out how to add a row and build a new table within a “For Each Row” Activity.
I’m already using REF and the “Get Transcation Data” part to loop through other information in a datatable(excelfile).
Is it possible to add new data rows in a For each activity and then pass the information to a new datatable?
I feel like it gets overwritten if a have it inside a For Each row Activity. Would be better if it worked like the “Get Transaction Data” in the “REF main”.