community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Help with Web Scraping

Meteor

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.

 

WSJ Libor Rates.png

 

 

Highlighted
Alteryx Certified Partner

Hi @msve ,

 

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

 

Screenshot 2019-04-02 at 15.10.45.png

Alteryx Certified Partner

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.

 

Screenshot 2019-04-02 at 15.15.29.png

Meteor

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

Alteryx Certified Partner

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

Labels