Error when using anchor to get text

Help Activities
, ,
1

Hello, I am trying to get data from web by using “Get Text” activity.
However, at a certain point on web, I can’t use “anchor” to locate the text I want.
When using anchor, the frame turn red. (as in picture)

image

image

This only happen when there are more than 1 row of the data I want to collect.

When I run the code it shows error
"Multiple similar matches found. Could not uniquely identify the user-interface element for this action. Edit the element, run validation, and add anchors in order to ensure the element is uniquely identified.
image

Questions

  1. Is there a way to create multiple anchors? If so, please explain how?
  2. Is “Get Text” the right activity for this task?
    My objective is to get each data value and put them into columns that I prepare beforehand.

Thank you in advance.

2

Hi,

I recommend to use UiExploer then check which attribute can be used. In this case we might be able to use TableRow and TableColumn and they might be stable than anchor.

Or it might be good to use data scraping (table extraction) to get table data as DataTable.

Regards,

3

Ok, I’ll try,
Thanks :slight_smile:

4

Hello @Cheatken
Instead of Get text activity, you can use the Data scraping method.
By using For each activity, you can achieve your task.

5

@Yoichi @Gokul_Jayakumar
Ok, I use “Table Extraction” and get new data table.
Is there a way to transpose from row to column so that I can put them in the table that I prepared?
Thanks

6

Use NovigoSolutions activity to Transpose the data
image
image

7

Hi @Cheatken

Check out the Link

Hope it will helps

Regards
Gokul

1 Like
8

Hi,

If you can use custom activity, there are some activities pack including transposing as the following.

image
image1454×516 46.5 KB

Or we can also transpose table using CopyPasteRange activity through Excel worksheet.

image
image599×584 13.9 KB

Regards,

9

@Yoichi @Gokul_Jayakumar @Gokul001
Ok, Thank you guys very much. I think scraping with “Table Extraction” is appropriate for this one. :slight_smile:

And thank you for transpose as well.

10

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