Extracting table data from multiple urls (not multiple pages)

[Data_Wizard]

I have an excel file which contains links of coaching staff of high schools under the column “Staff Link”. I want to open each link and extract the name of every head coach and assistant coach which is present as a table in each link. Save it into a new excel file along with Rank, High School Name and Staff Link. When I run my flow it always extracts the table data from one specific URL and not the different URLs. I am also attaching the XAML file. Can someone tell me what I need to change?

Main.xaml (21.2 KB)

High School Ranking Missouri 22-23.xlsx (8.9 KB)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Data_Wizard ,
can you share your link get data,
I think we need extract each data in each url, then merge them to 1 data table
regards,

[Yoichi]

Hi,

Can you try to insert the following Assign activity just before ExtractTableData because datatable proeprty of ExtractTableData is InOut type and it’s appended to previous data?

ExtractDataTable = Nothing

Regards,