Skipping a row in HTML table

Help
, , , ,
1

I have a web based table and I will need to skip a row, if it doesnt meet certain criteria, and go to the next row. if it does, click on the atm number. I am having trouble getting it to click on the next one if it has to skip a row. I have done data scraping into a datatable. If there are rows in the table, I have a for each row. The picture is a copy of the table. any help is appreciated.

atm
atm438×516 4.57 KB

2

@mlmyers

First you need to scrape data and then use a counter on the selectors.
do you have an initial project?

image

See the image, we use a variable count in the selector with a subsequent increment

image

obs.:
the selector is a click activity

3

Hi @mlmyers
B@sed on th@t we c@n extr@ct by doing d@t@scr@pping

Extr@ctD@t@t@ble.rows.skip().CopyToD@t@t@ble()

Th@nks
@shwin S

4

@KMota
Thanks for the prompt response. editing the click selector does not appear to work for me. I have included pics of the workflow, and the message I am getting. I may have something wrong. thanks789 456

123
123545×666 22 KB

5

thanks for that. where would I put that logic?

6

I would not do any of that, dont use scraping when you dont actually need all the data… just get the selectors you need from the first row and identify how to get the same values from the other rows, after that use an “infinity” loop with a try/catch that will be there to end the logic when there are no more rows (if you dont have a counter).

7

Let me see your project

8

test1.xaml (24.6 KB)

9

@mlmyers

Try repositioning your click activity. indicate on the screen the first line you want to click. Then enter the Selector and edit including the variable according to the activity selector. Can you attach the selector before changing it?

10

this is the selector after I indicate element:

012
012702×468 24.2 KB

11

You changed the selector in Open in UI Explorer?
Remove it
id - idx

can you show me this screen from Ui Explorer

image
image1098×416 26.9 KB

12

One way to verify that the table is being extracted correctly is to use the append range. So we can verify if the problem is with the lines or selectors

image

13

Here is the UIExplorer. The table is being extracted correctly. I verified that first.

345
3451093×708 36.1 KB

14

Hi @mlmyers

Is your problem still going on?
if yes, leave only Tag / tablerow / parentname selected. After that, with the right select the tablerow and transform into the variable

15

It is. What should the variable type be?

16

I have resolved this. it was the way I was adding the variable to the selector. At first I was clearing out the original selector and copying and paste the new selector with the variable inside. what worked for me was going to the side, not selecting the […] but editing inside. delete the original value, add both quotes, inside the quotes add both plus signs (++), inside the plus signs, when you start typing the variable it should appear for you to select. I also had to add.toString to my variable. Hope this helps the next person.

17

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