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.

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

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

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. 

7 - Meteor

This was really helpful and it workd. Thanks so much