Extract table data wizard (dynamic selection)

Help Studio
, ,
1

I was trying to scrap a data table from a website using the “Extract Table Data Wizard”. However, it seems successfully getting the value in the cells but the names of the column do change accordingly.

Therefore, may I know whether there is a method that I can also get the dynamic changing data from the website?

WhatsApp Image 2024-10-16 at 23.25.14
WhatsApp Image 2024-10-16 at 23.25.141244×436 94.3 KB

2

Hi @Komom

Can you try like below

  1. Targeting methods select Fuzzy Selector and uncheck Strict selector

The image depicts a UiPath Studio workflow where data is extracted from a web table on a specified URL and written to an Excel workbook, with the properties panel for the "Extract Table Data" activity displayed on the right. (Captioned by AI)
The image depicts a UiPath Studio workflow where data is extracted from a web table on a specified URL and written to an Excel workbook, with the properties panel for the "Extract Table Data" activity displayed on the right. (Captioned by AI)1248×727 147 KB

  1. Copy the Strict selector and Paste it in Fuzzy selector then make it empty Strict selector

The image shows a UiPath workflow for extracting table data from a webpage and writing it to an Excel file, highlighting the "Extract Table Data" activity with fuzzy and strict selectors settings. (Captioned by AI)
The image shows a UiPath workflow for extracting table data from a webpage and writing it to an Excel file, highlighting the "Extract Table Data" activity with fuzzy and strict selectors settings. (Captioned by AI)1458×825 74.6 KB

Finally it look likes below

This image shows a UiPath automation workflow sequence that navigates to a webpage, extracts table data, and writes the data to an Excel file, alongside the properties pane highlighting options such as fuzzy selector, strict selector, and targeting methods. (Captioned by AI)
This image shows a UiPath automation workflow sequence that navigates to a webpage, extracts table data, and writes the data to an Excel file, alongside the properties pane highlighting options such as fuzzy selector, strict selector, and targeting methods. (Captioned by AI)1458×829 75.8 KB

Regards,

3

Hi @lrtetala
When I copy these into Fuzzy selector, error occurs and cannot work. How can I solve this?

WhatsApp Image 2024-10-17 at 14.09.31
WhatsApp Image 2024-10-17 at 14.09.31683×562 45.6 KB

4

Hi @Komom

Can you please try this workflow, let me know if it works.
ExtractTableData.xaml (13.3 KB)

5

Hi @rashmisingh2695 I am unable to open your file

6

Please refer the screenshot

This image shows a workflow in a browser automation tool, designed to extract table data from Google Finance and output it as text. (Captioned by AI)
This image shows a workflow in a browser automation tool, designed to extract table data from Google Finance and output it as text. (Captioned by AI)724×838 30.6 KB

Open browser selectors
This image is a screenshot of the Properties panel for a UiPath activity, showing settings such as "Common" and "Input" properties, with emphasis on the "Selector" field which contains HTML code for a Chrome application targeting "Google Finance". (Captioned by AI)

Extract Table data properties

  1. Used Fuzzy Selectors
  2. Changing Column Name replaced with wildcard *
    The image displays a software interface for setting target input parameters, including selectors and control types, typically used for web automation or UI testing. (Captioned by AI)
    The image displays a software interface for setting target input parameters, including selectors and control types, typically used for web automation or UI testing. (Captioned by AI)520×598 86.9 KB

    A screenshot of a data extraction configuration in an automation tool, showing the "Extract metadata" section with XML code for table extraction. (Captioned by AI)
    The image shows a section of a software interface with metadata extraction settings and an XML table configuration snippet highlighted under "Table settings." (Captioned by AI)
    The image shows a section of a software interface with metadata extraction settings and an XML table configuration snippet highlighted under "Table settings." (Captioned by AI)547×526 126 KB
7

@rashmisingh2695 Thank you so much! It worked.

1 Like
8

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