Help with Web Scraping

[msve]

Hello,

I am very new to Altreyx. I am trying to scrape LIBOR Rates data from site - https://www.wsj.com/market-data/bonds . Site has different tabs for US, Euro,Pound,Yen rates.I was able to get US rates because its deafult on the website but how do I get different rates? Do I have to create RegEx for each of them? Also, the values change dynamically when we select the tab. Please see screen shot below. I have also attached my workflow.

[jamielaird]

Hi @msve ,

Looks like they are all in the source code so it should just be case of writing a Regex expression for each:

[jamielaird · Accepted solution]

Since they appear in a JSON object it's easier to get to them if you split to rows on { and then filter for the words "Libor" and "ticker". There may be better ways but that seems to get most of the way there. See below and attached.

[msve]

Thank you so much for your response. This looks good.I will try to clean up the data. 

[jamielaird]

You're welcome. Please mark my response as solved :-)