How to extract table data


My target is to extract this table, i don’t know which activity extract this table?

Any suggestions?

Thanks in advance.!

Hi @chandu_rsr,

I would suggest try Data Scraping wizard,
image

here’s one doc on Data Scraping, this might help you in this.

@chandu_rsr
Can you please Share the url, so WE can Cross Check Out solution suggestions. Thanks

1 Like

@chandu_rsr
Most of the relevant data are found under DL (Defintion List) on the DD, DT.

As for the DD,DT Pair Sequences not a row iterator can be defined, so Datascraping will not be configurable for this retrieval.

In this scenario I would suggest to work with find children on the DL’s. In a subsequent step the DD,DT’ can be processed e.g. with dynamic idx selector or over additional find childrens.

Let us know your open questions

1 Like

It is a so confuse site. You will need help from this:

@chandu_rsr
as already mentioned the structure is cross composed. As there is not rowiterator defineable it cannot managed with data scrapping.

However in rogh prototype it was manageable with the combination of different techniques. Here is the result:
grafik

Part One:
can be done classically with get text:
grafik

Part Two:
grafik

  • with find children the two DL can be retrieved
  • with another find children the DTDD series can be kept:
  • with a modulo dt dd are used for constructing the datarow array

grafik
for sure this done within a few nested loops

Part Three:
grafik
find children to the divs with class col* taking col, col d-non… ommiting w-100

the first half are the timings, the second half are the info
grafik


with the uielement api we can do a find firstr chidren and retrieving the alt from image

Kindly note this was POC / quick prototype, so for production level some finetuning / dynamzing is recommended.

Demo XAML here:
worldweatheronline.com.xaml (23.3 KB)

Let us know your feedback

2 Likes

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