Forum Discussion

Marcio Flores's avatar
Marcio Flores
Copper Contributor
Feb 28, 2018

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

Resources