Data table extraction

Help Activities
, , ,
1

Hi guys
Am trying to extract the data from the below type of structure but while am using the Data scraping it will only extract the headers of the table. Please any one does some needful…

Screenshot 2022-09-08 020831
Screenshot 2022-09-08 020831293×624 28 KB

2

Hi @Prasanth_98

Welcome to UiPath community

Have a look on the document for more clarification

Regards
Gokul

3

Yes, Gokul I know this is the process of scraping the data but the exact problem is I mentioned below…

Screenshot 2022-09-08 022151

4

Screenshot 2022-09-08 022132

5

Hi @Prasanth_98

Have you give yes to extract whole table?

6

@Gokul001
Yes I did but it will only extract the headers

7

Give first and second data in the Check Date column @Prasanth_98

8

The data I was mentioned in the first post

9
10

@Areej_fatima This will not help me, the structure of the data I mentioned was totally different & it is very difficult to extract

11

Is it web base or excel sheet?

12

This structure is in the web

13

Use Table Extraction
image

14

@Prasanth_98 If you are not able with Data Scrapping, you can make dynamic selector and put in loop and then get data by get text activity

15

@Areej_fatima Same thing is happening

16

@raja.arslankhan
I need this data in excel for log purposes…

17

Can you please explain how to implement this

18

Hi @Prasanth_98

Can we cable to access the website, If yes Share website link

19

@Prasanth_98
please follow these steps.
1- use two get text activity one for check date and one for check amount.
2- get selector for first row.
3- check selector, it is possible to make it dynamic so that we can put variable in selector

20

@Gokul001
Am Sorry it’s a secure portal so i cannot able to share it…