Please help me generate data from the below url into Alteryx as an input for further analy

[duttaabhishek]

I want to generate the table on the left hand side where the country names are appearing and the count mentioned beside each country. I want to generate those data into excel as input. Please help with a workflow for the same

https://fcpa.stanford.edu/geography.html

[bgreedy · Accepted solution]

Hi, please see the workflow attatched

I extract the data using the download tool, and then use the regex "<ul id="mapnav".*?</ul>" to get just the table we want to extract, then split the data by new line to get a row for each record, then extract only the elements we want. 

[duttaabhishek7 · Accepted solution]

This was really helpful and it workd. Thanks so much