Scrape the details with title

Help Studio
1

How to get the value and title from website in one go without using "get text " activity for each value?

Currently i am using get text activity for each and store into DB

image
image810×828 49 KB

Expected output :

image

2

Hi,
To extract both the value and title from a website without using separate “Get Text” activities for each value, you can use data scraping techniques in UiPath.

  1. Use the “Data Scraping” wizard:

    • Use the “Data Scraping” wizard to extract data from the website.
    • Indicate the first element you want to extract (e.g., the value) and define the data pattern by indicating other similar elements.

  2. Configure the data extraction:

    • Define the columns you want to extract (e.g., Value and Title).
    • Use the “Extract Correlated Data” option to capture related information on the same row, like Value and its corresponding Title.

  3. Refine the data extraction:

    • In the wizard, you can preview the extracted data and make adjustments to ensure accurate extraction.
    • Use the “Edit Data Definition” option to refine the data extraction further.

  4. Finish the scraping:

    • Confirm the data extraction and save the output to a DataTable.

  5. Process the extracted data:

    • Use a “For Each Row” activity to iterate through the DataTable.
    • Inside the loop, you can access the “Value” and “Title” columns of the current row and process them as needed (e.g., store in a database).
3

I don’t get Extract Correlated Data option in extraction wizard

4

Hi @Sathish_Kumar_S ,

We could also try to extract data with the one Get Text activity for the Larger Area than each specific Values and then perform String/Regex Manipulation methods to get each values from the Extracted text.