Web Scraping -Almost there

[msve]

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.

[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 🙂

[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?

[TheOC · Accepted solution]

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!

[msve]

Hi @TheOC ,

This is exactly what I wanted (wanted data until the row with timestamp) :).  Thank you so much for your help  😀

[TheOC]

no worries at all! Glad i could be a help, have a great day ahead!