Forum Discussion
Marcio Flores
Feb 28, 2018Copper Contributor
Help with Queries and Connections, Data from Web from multiple URLs
Hello,
I have a list of about 75 webpages within the same website from I want to target an specific table on that page. I have been doing one by one, (please see file attached with one sample set of extracted data) by copying the URLs which I previously ewith multiple sources for Data extraction from straced and placed on an excel sheet as individual links. From there I basically copy and paste the link on the first query dialog box, then on the Navigator window, I select the table I want ( it is usually "Table0") and click on "load". ... I figure that there must be a better way to automate this extraction. How do I do that?
Here is the example link:
http://www.usendoscopy.com/Products/roth-net-retriever---polyp.aspx
There is only one table contained on this page (pictured) which liss product details but I don’t know what the sintax is to target it for extraction on Queries and Connections --> From Web, or if that is even the bes way to extract it.
No RepliesBe the first to reply