Extract specific data from a structed data on a website

https://www.ciclt.net/sn/clt/capitolimpact/gw_default.aspx

On this website I have country table

image

In this I want to only on the country abbreviations but while extracting data those US Congress US Executive nd US Judicial Columns are also getting extracted I want to ignore those above 3 and only need to capture this much of data as I have shown below

image

you mean you dont want these 3 headers in your extracted data?

try this @Ishan_Shelke1
Main.xaml (9.9 KB)

  1. find children with filter tag=TH
  2. loop over children,
  • get tableRow attribute , if tableRow <=2 (top row), skip
  • otherwise , get innerText attribute (State name)

result
image

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