I am trying to extract a cell information from a scrollable table in my remote machine using the CV Get Text activity but the bot is unable to find the correct cell (the correct row in the table).
Example:
The Table contains employee details (Column A: Client ID, Column B: Client Name, Column D: DOB, Column E: Address, Column F: Net Worth)
The table is scrollable in the remote machine.
I am trying to find the Client ID using the Client Name, DOB as reference in the CV Get Text activity
The syntax I am using is as below
“Target: TableCell (2,266,1811,687)” +
“ColumnName: Client ID (399,266,120,25)” +
“RowContains: Suresh Choudhary (2,546,89,17) RowCell: 2”+
“RowContains: 14/09/2021 (243,665,86,17) RowCell: 3”
But the BOT is only able to find the first instance of Client Name in the table and extracts the Client ID respectively, it disregards the DOB of the client. I want the bot to use both Client Name and DOB when it does a search in the scrollable Table.
Is the Bot running on your Machine and that’s the reason you are using CV Get Text or is the Bot running on the remote machine? Could you possibly provide a screenshot?
I am trying to extract data from a table, once I extract the data I need to validate the extracted information and enter a value in the same table for the validated row in column X.
Then try getting the row from the extracted data…then try making the cv descriptor dynamic to click at the required place or type into at required place…this might need some analysis from you to change the descriptor anchor values and all…try modifying it and check which fits best…Target table cell is what you need to try and modify as you need
Double anchors on Descriptor might not work as expected
I am trying to do the same thing but the issue is the bot only returns the row for the first instance of the first anchor and not able to take more than one anchor.