Hello everyone (my first post here)
I’d like to ask for help:
I have a loop “for each row” and each item of the loop is used in a following sequence:
- searching data on a specific website
- web scraping of obtained data and saving it to a DataTable (called ExtractDataTable in my workflow)
- modifying this dt by adding columns with specific data
- appending this dt to a final excel file (called final_part_list.xlsx in my workflow)
What’s important, in the final file I need to have appended data from processing each item of the loop.
The workflow works fine only for the first item of the loop. Each next item causes fault in “Add Data Column” (it says dt already has the column I want to add) and in “Append Range” (it says that range does not exist).
I assume that I should use some kind of additional assignment when the loop starts in order to have the datatables reusable, but I have no idea how to do it.