How can I scrap the value from web with the same position in loop?

Help Studio
, ,
1

How can I scrap the value from web with the same position loop? I can only receive the same value in a loop.

Example: Collect the rating of movie from the same position, but the rating would be changed by different movies.

rating
rating1278×508 65.7 KB

thank you

3

Hi @Sanwa ,

In your selector change aaname value to “*”. If the position is same then on each page it will fetch the current page rating.

1 Like
4

Hi @manjula_rajendran ,

Thanks for your reply, I changed the aaname value to “*” but it turns out empty when I kept the data in the Excel…

5

My work-flow:
WHILE LOOP environment:

  1. Scrap data table from web in same position
  2. keep them in Excel
  3. Scarp another data table from web in same position
6

Can you share the webportal url? i can give you exact selector

8

Hi @manjula_rajendran,

Thanks for your reply, let’s take https://www.amazon.com/ as an example.

My workflow:

amazon_4
amazon_4840×610 19 KB

amazon_5
amazon_5714×786 43 KB

I will import a data table first,
then in while loop:

  1. Type input “hair clip” and use “data scraping” to get the first product name of the result.

amazon_1
amazon_11476×688 112 KB

  1. Get the name and save it to the excel
  2. Type input “hair gel” and use “data scraping” to get the first product name of the result.

amazon_2
amazon_21504×685 293 KB

  1. Get the name and save it to the excel
  2. The expected result:

amazon_3
amazon_31178×252 4.03 KB

I always get the same product name or empty name in the excel, how can I reach and get the expected result?

Thank you!

9

Hi @Sanwa ,

It is overriding the data. As you are looping inside and each time new data will override the old data. You can create a one more output datatable and after scraping the data merge the data to output datatable.

Here i attached the workflow.
AmazonScrap.xaml (17.5 KB)

Hope it will hep.

Thanks,
Manjula

1 Like
10

Hi @manjula_rajendran,

I tried you method but it turns out empty, is anything I did wrong?

AmazonScrap.xaml (17.3 KB)

Thankyou so much!!

11

Your workflow has some issue. I’m not able to open.

image
image1023×500 24.3 KB

Download the attached my workflow and run.

AmazonScrap.xaml (17.5 KB)

I’ve attached the result for your reference.

result.xlsx (9.1 KB)

12

Hi @manjula_rajendran

Thanks for your patience, this is the result that I got.
May I know where is going wrong? Thankyou!!

amazon_result.xlsx (11.0 KB)

13

Hi @Sanwa,

Please check your input table.

I’m passing Hair Clip twice.

image

14

Hi @manjula_rajendran ,

Here is my input table:
ama1

Selector of attach browser:
ama2

Properties of Extract Structured Data:

ama3
ama3541×572 15.6 KB

Thank you for your help!!!

15

Hi @Sanwa ,

In attach browser selector change title=‘Amazon.in : Hair Clip’ to title=‘Amazon.in : *’

Attached your same workflow with modified. Please check it.

AmazonScrap_1.xaml (17.5 KB)

1 Like
16

Hi @manjula_rajendran ,

Thanks for your reply,

I have changed the selector to “*” but it still doesn’t work.

ama4
ama4700×527 19.3 KB

Here is my workflow:
AmazonScrap.xaml (17.5 KB)

My result:
AmazonResult.xlsx (9.3 KB)

17

Hi @Sanwa ,

Please try with this workflow
AmazonScrap.xaml (18.8 KB)

Here is output
AmazonResult.xlsx (10.4 KB)

1 Like
18

Hi @manjula_rajendran ,

Before I run your workflow, the only thing I need to changed is the Excel path?

Do I need to make the data scraping again? Since the images are not available.

Really thanks for your help.

19

no need to change anything…you can run directly. Excel path is also same.

Just run the flow