Web Scraping -Almost there

Hello,

I have created workflow that gets data from WSj website (https://www.wsj.com/market-data/bonds/treasuries?mg=prod/com-wsj). I have noticed that its brining in more columns than expected. Ex- Website has 312 rows of data but Alteryx is bringing in what looks like duplicate data but its not. How do I remove rows that I don't need (in this case I don't need rows after record 312). Also, how do I export this as an word. I tried using render tool but was not successful.

WSJ.yxmd

Reporting

Output

Custom Tools

Text Mining

Accepted answers

TheOC

Hi @msve
Yeah ofcourse! Do you want the row with the timestamp too? Or is that part of the ones you don't want?

If you do want it, I use a multi-row formula to apply a "unneeded row" value to each timestamp after the timestamp, then a simple filter to get rid of all of those!

I have attached the workflow below!

WSJ.yxmd

All comments

TheOC

hi @msve

if you only need tthe first 312 rows of data, the sample tool is best for this:

Configured with first N rows, you can specify N to be 312!

TheOC

@msve
I believe I got this working, as seen below:

This did output to a word file, i believe its best to use a table tool first and then plug that into your render tool, I've attached the workflow!

Let me know if i can help any further 🙂

WSJ.yxmd

msve

Hi @TheOC ,

Thanks for your response. This is going to run daily where new rates are added to WSJ almost everyday. So, today we 312 rows of data but it could be more tomorrow. Is there a way to ignore rows after the "timestamp" column is populated?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335