This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 .
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.