I have 2 columns - Name & URL. These column store a client name the URL extension to that page.
I want to create a new column called CT_Name. This is a link that exists on each Name page that stores rows of CT_Names.
I want to loop through each URL row in my data table (works fine), navigate to the CT_Name page (currently using Navigate To and Click action which works fine) and then scrape the structured data to the new CT_Name column for each Name row.
But I want to make sure that the CT_Name rows are only added to the Datatable where the URL matches as there are multiple CT_Name entries for each Name.
How can I do this?
Thanks for your help