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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

How Do I take Data from a website and paste in Excel

Highlighted
Atom

Hello Community,

 

I have a repetitive task of going to a website and pull data every month for different banks(24)(http://www.osfi-bsif.gc.ca/Eng/wt-ow/Pages/FINDAT.aspx).So on that link I have to choose different banks & month. How can I pull this data automatically instead of copy/paste. I have tried with the below screen shot but its not working .

thanks for the help!!

 

DOWNLOADINGDATAFROMWEBSITE.JPGDOWNLOADINGDATAFROMWEBSITE2.JPG

Alteryx Certified Partner

Hey @mointdct 

 

HTML is not structured enough for the XML tool to parse it succussfully...I would use a combination of regex and formula tools to extract the data you want

Bolide

You will need to download the site and probably tokenize to rows based on a pattern and then parse all of this using Regex tools. Please let me know if this helps.

 

Thanks,

Seth

Pulsar

Does the problem lie in getting the information from the different banks (i.e., needing to fill in the website form 24 times), or once you have the data into Alteryx?

 

If the former, perhaps there is an API that you can link into in order to grab the information. I'm not seeing anywhere on this particular page where you can automate the process.

 

If you can pass the bank and report information back to the page, you could set up a batch macro that downloads the information from each bank, parses it into a usable format, and creates whatever output you need.

 

Let me know if that's helpful

 

Cheers!

Esther

Labels