Help with Web Scraping

[taxguy33]

Hello,

I am fairly new to Altreyx. I am trying to scrape the US Prime Rate and the Effective Date data from site - https://www.wsj.com/market-data/bonds/moneyrates . I'm not good with viewing the HTML and/or how to view that in Chrome and especially in Alteryx. I'm assuming I might need to do a RegEx type expression tool to try to pull that one rate, but very much an amateur on this topic. Anybody have an idea of what this workflow to scrape this data would look like?

Thanks!

[AndrewS]

Hi @taxguy33 

Weekly challenge #40 would be a good place to start - it looks at HTML files.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-40-Parsing-a-HTML-File/m-p/36581#M17

A lot of the posts contain alternate regex approaches which should give you some direction on how to parse the page.

I find Regex101.com is also useful for testing.

[RishiK · Accepted solution]

Hi 

I started a workflow for you as attached.  Take a look, you will probably need to polish it or modify based on the data you want back.