How to get a bot to click on the right row in a datatable

[jeff.shubzda]

The bot is reading 2 data tables to compare numbers, if it finds a number in the row that doesn’t match it has to click into the application on that particular row.

So for this example the bot ran the first row of scraped data, and it was fine but hit the 2nd row and found that “see notes” so what the bot has to do is click on that 2nd row in the application to activate the application so it can update that see notes to a number. Right now it’s clicking the 1st row. My guess is it has to do a count to know that it’s processing row 2 and apply this variable to the click activity in some way?

[shreyash_shirbhate]

@jeff.shubzda

2 data tables

Hi @jeff.shubzda,

Please check this out:

Clicking each row of a specific column in a table on a website

I want to click each row of the column “Dokumente”. My current solution is to do a Data Scraping of the table (selecting column “Dokumente” and one other column). Then I implemented a “For Each” activity referring to the output variable (DataTable; Default: NewSystem.Data.DataTable) of the Data Scraping. Then I come to the first issue: The “Double Click” I implemented thereafter is not working. The robot always clicks the first row (in a loop → so it would be endless without any progress) S…

[Nithinkrishna]

Hey @jeff.shubzda

Could you please share how are you calculating the row number ?

Also, check if the row selector has row number equivalent like 2 for second row, 3 for third row and so on.

If not the logic should be adjusted accordingly.

Hope this helps.

Thanks
#nK