Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

duttaabhishek
7 - Meteor

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

2 REPLIES 2
bgreedy
7 - Meteor

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
7 - Meteor

This was really helpful and it workd. Thanks so much

Labels