How to extract data from multiple tables on single webpage

Help Robot
,
1

On a some web page I have Single table

image

and on some page I have 2 tables or say three like this

image
image712×516 11.5 KB

How Do I extract data accordingly and paste this data into a excel file

2

whats the website link for page with 2 or more tables?

3

again, similar logic as your previous question…
Extract Zip Code Details.xaml (13.4 KB)

  1. use find children, set scope = FIND_DESCENDANTS, set filter as
    "<webctrl tableRow='1' tag='TABLE' parentid='MPBody' />"
  2. for each child element (table), use data scraping to extract table, then merge tables into finalTable

Example

image
image1136×417 20.3 KB

Result
image

Note: you can identify the filter as follows:

  1. get selector of 1st table
    "<webctrl tableRow='1' tag='TABLE' parentid='MPBody' idx='1'/>"
  2. get selector of 2nd table
    "<webctrl tableRow='1' tag='TABLE' parentid='MPBody' idx='2'/>"
  3. the attributes these 2 selectors have in common will be your filter
    <webctrl tableRow='1' tag='TABLE' parentid='MPBody' />
1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.