Extract table data is not working for multiple ids dynamically

Help Activities
, , , ,
1

HiAll,

Extract table data for one id it is working fine, for all other ids im getting first data, data is not changing dynamically in same format for other ids, Is there any settings do i need to update.

Thanks,
Niranjan

2

Hello @niranjan.kummara

Could you plz share a screenshot of the Table that you are trying to extract??

Also are you using the Table Extraction??

Thanks

3

@Rahul_Unnikrishnan, please find the below screenshot on green highlighted security cell ids will change dynamically. i have to pull data respective id. but im getting 1st data for all other ids.

image
image

4

@niranjan.kummara

So the id you need to pass using a for loop and then you have to use the table extraction.

(As per the screenshot, selection of id can be done using select item activity)

So when ever the Table for the new id is updated it will extract those data. Then you can write that to excel or other destinations

Thanks

5

@Rahul_Unnikrishnan Any sample workflow or video for reference, As im new to UiPath it will help me if you can shared any reference videos.

6

@Rahul_Unnikrishnan From below url how can i update fuctionality to update secid dynamically.
“[https://Activedata.com/desktop/cgi/sec-info/sec-info.cgi?idctoken=&tuser=&func=CA&subf=&secid=030371108]
image

7

This url is not accessible.

For selection of ID you will have to use Select Item activity. Once the respective id is selected, then you need to do the data scrapping.

Or are you facing issue while scrapping the data with the change in the id?

Thanks

8

@Rahul_Unnikrishnan, Yes while Scrapping the data with change the id im getting error.
Initial building the workflow what ever id i have used it is pulling the data, for other ids im getting blank details. I thinking i need to make this dynamic for when changing the id loop the same logic.

9

can you share the selector used in the Datascrapping?

Thanks

10

@Rahul_Unnikrishnan, please find the below image i have used selector for datascrapping.
image

11

can you copy that and paste it here. Want to see any attribute related to the id is there in the selector.

Thanks

12

@Rahul_Unnikrishnan,Thank you It is working but now im getting one more error,
Join Data Tables: the value for argument ‘Column Name’ is not set or is invalid. any suggestions please

13

If you dump the datatable to a CSV file it can help you spot what is missing, and therefore what you need to do to handle it.

Also looping selectors is really slow. If possible, I like to use Find Children to just grab everything from the page matching some criteria (e.g. a td with a certain class+parent), then I loop through the output in-memory. Takes something from like 30 seconds down to just hundreds of milliseconds - and is more reliable generally speaking.

1 Like
14

@Legoman Sure thank you, i will follow your suggessions. but im getting one more error at the end
Write Range: Object reference not set to an instance of an object. how shuld i fix, any suggssions please.

15

@niranjan.kummara you datatable variable should not be null and make sure you mention the datatable name in the datatable field in write range activity

16

@sangeethaneelavannan1 Thank you

17

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