Extract multiple elements having the same anchor text

[Data_Wizard]

Hi I am a new UiPath studio user. I have an excel file with a list of websites. I am trying to build a flow that accesses every website link. Each website has the name of head coach and multiple assistant coaches. On the website the name of Head Coach is written above the text “Head Coach” and name of assistant coach over the word “Assistant Coach”. Can someone help me extract all these names and their designation into a one datatable. Input datatable is as follows:

Rank	School Name	Staff Link
1	Liberty North (Liberty)	Staff - Liberty North Eagles (Liberty, MO) Varsity Baseball 23-24
2	Nixa	Staff - Nixa Eagles (Nixa, MO) Varsity Baseball 23-24

[Palaniyappan (Palaniyappan P)]

Hi

Welcome to UiPath forum

If you have the list of website then u can out them in an excel file and read it as a datatable dt
Then iterate through each row using for each row in datatable and open the link one by one
Now use table extraction method to get the data from those websites

Refer these threads where discussions happened on same note

How do I **Extract Table Data** with hyperlinks from a webpage?

@PeruT it can be achieved while configuring the custom datascraping: start Datascrapping Wizard indicate first cell click no for configure first column (indicating firdt and second cell) click on extract correlated data indicate first cell Company column configure: [grafik] click on extract correlated data click on first link, second link, configure: [grafik] get: [grafik] and so on Kindly note to enhance the retrieved link withe base url info: retrieved: market-activity/ipos/o…

Uipath- Table Extraction| How to extract table and pattern based data| Extract URLs

Hope this helps

Cheers @Data_Wizard

[Data_Wizard]

This worked! Thank you very much @Palaniyappan

[Palaniyappan (Palaniyappan P)]

Cool
Then would recommend to close this topic

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

@Data_Wizard