This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The attached solution utilizes observed specifics in the HTML to extract the relevant rows generate the Abbr/CountryName list in straight-forward fashion. Granted, if they tweak the table, results may go bad, but that may well be the case with any solution.
(But as noted above, import.io is probably the way to go here: it captures every column in the table).
There's a few different ways of Parsing the html table listed here, so I thought that I would include mine. The base of it is around using REGEX to parse each element to a new line (I used to replace each element with a pipe (eg Replace([DownloadData],"<table","|") and then parse on the pipe before I got used to REGEX).
I'll also jump on the love for Import.io, as once the page gets a little more complicated than a simple table, Import.io handles those elements better.
This is helpful, I'm familiar with import.io so will use that as it is the easiest here.
I just can't wait for such functionality to be embedded in a proper Alteryx tool because all the parsing methodologies outlined here are way too long for me, I'd be quicker copying and pasting the table in a text input and refresh it manually 🙂
Anyway this gives me ideas for other stuff so thanks for spending the time