Extracted data is not showing in data table output. But at the time of data scraping or table extraction, data is showing

Help Studio
, ,
1

At the time of scraping or table extraction for one column data is visible in preview but in output, extracted data is not coming.

2

Hi @vnsatyasunil

You might check your selector, maybe is its taking the wrong element, also check if you set the extraction correctly

Regards

3

tried with table extraction now I got data like this
number sort in ascending order
state(Y)
POC345678
POC786759
POC652388
POC776655
I want like this
number
POC345678
POC786759
POC652388
POC776655
Please help

4

a didn’t get your point, i see the same data, could you elaborate?

Regards

5

need to remove sort in ascending order & state(Y)

6

Try saving the DataTable to an Excel sheet and check if data is properly extracted.
And For sorting, check the properties panel, to know more about how the data extracted is saved into the DataTable

7

we would recommend to ectract the data as done and then afterwards cleansing up the result e.g. with filter datatable, LINQ…

8

need to remove lines sort in ascending order & state(Y)
from line POC345678,need to add it to queue.

9

Hi @vnsatyasunil - I’m assuming need to remove lines sort in ascending order & state(Y) is the header of the data table, if not instead those are the rows in a data table then, you can remove those rows using Remove Data Row activity

Doc - https://docs.uipath.com/activities/other/latest/user-guide/remove-data-row

Provide Row Index and the data table name (below screenshot)

FYI - Row Index starts from 0, means, first row index is 0, second row index 1…

Picture1

10

how to pass row index to remove first 2 rows in remove datarow activity?

11

@vnsatyasunil - Take 2 Remove Data Row activities, in the first one pass Row Index as 0 and your data table name. Now, in the next activity, pass Row Index as 1 and again your data table name

FYI - We can’t pass multiple row indexes in the same activity. So, you have to use multiple Remove Data Row activity to delete each row.

1 Like
12

Thanks.It worked

13

@vnsatyasunil - Great! If there were no other issues can you please close this topic by choosing appropriate post as solution. This way it would help others facing the same issue

14

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