I have a problem when creating DataTables in a for Each Activity.
The case is as follows: Based on an Excel-file (Input) I searched on google.nl to company names. Then I want to extract a table for each row (input) and add all of the extracted data (datatables) in 1 excel file (separate sheet names for each datatable/row).
My robot overwrites the created datatable, so I only see the first company in the created Data Table within the for each activity.
How can I create separate Datatables (based on input/company names) within a for each activity and add all of the extracted data in 1 excel?
Many thanks in advance.
Kind Regards, Teun