How to compare two value and click on column

[RAKESH_KUMAR_Tiwari]

Hi All, @Anil_G

i have a data in excel and i want to match the data with website, if matches then need to click on the next column of website(Count).

img reference for website

img for reference of excel

Also, let me know, if the excel has a pivot table, then will the BOT able to read the data? because i might have a multiple sheet and might have designed in Pivot .
How to achieve?

[RAKESH_KUMAR_Tiwari]

i have tried this way.

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

As it is a table you will have table row and table col…

first use the value from excel in the innertext value and use get attribute to get the tablerow number

<webctrl tag='td' innertext='{{CurrentRow("Organization").ToString}}' />

Then use the tablerow obtained in get attribute to click on the next col

<webctrl tag='td' tablerow={{varTablerow}}' tablecol='2' />
<webctrl tag='A'  />

if multiple pages are there then we need to add logic to check each page also

Mostly selectors look like this

cheers

[RAKESH_KUMAR_Tiwari]

Hi @Anil_G ,

used click activity and click on one of the organization in website and edited selector like this

Again used get attribute activity and indicated the same organization column in website.
saved in table_Row.
Again used click activty and click on count column and edited slector like this

is this correct?

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

Wrong…use get attribute and it should use only innertext theh value returned from it to be used in the next selector for click

cheers

[RAKESH_KUMAR_Tiwari]

Throwing error

just copy paste your sek\lector as i am not able to write it manually
‘{{CurrentRow(“Organization”).ToString}}’ />

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

I dont want you to copy…the selectors are only for illustration…

Assign the currentrow required column value to a variable and then right click in your selector and choose the variable there

Cheers

[RAKESH_KUMAR_Tiwari]

Hi @Anil_G ,

It is clicking properly, but why it is throwing error, it feels like it is trying to click on next element perphaps.

[Anil_G (Anil Gorthi)]

@RAKESH_KUMAR_Tiwari

Are you running this in a loop?

If yes then the screen should be reset to the initial position after first iteration else the screen wpuld have changed and it would not find

Basically your actions would be like this

1. For loop
2. Get attribute using innertext as variable from for loop row
3. Click Using tablerow from get attribute output
4. If extraction is part here…then extraction
5. Perform actions to come to first pag
6. Loop end next iteration starts

Cheers

[RAKESH_KUMAR_Tiwari]

yes, it is in loop.

ok understood once i finish the extarction part, then it will go to next iteration.

Thanks
Rakesh