Hi! I have a similar situation. I have 2 tables—Clients and Letters. The Clients datatable has 2 columns—ClientName and Completed. The Letters datatable has 4 columns—ClientName, SentDate, LetterId, and LetterType. What I want to do is have the bot scrape the list of Clients and place the list in the Clients datatable. It will then perform a For Each Row action using the Clients datatable. The For Each Row activity will search each client name, click on a few links, then scrape another table and place the list in the Letters datatable. When it scrapes the data, I want it to add the ClientName for each row of the new datatable (Letters) where the ClientName column is null or blank.
The process has activities that build the datatables because there are columns that do not exist in the scraped data tables—the Clients table on the website does not have “Completed” whereas the Letters table on the website does not have “ClientName.”