Facing issues while using data scraping in for each row


I need to run data scraping for 3 locations and paste to an excel ,so i used for each row, but am getting the same output instead of location changes.

The thing is first which ever data i scrapped that is coming to all the 3 locations.

If am not sure we need to use selectors in this,if so can u tell me how to use,because i tried using but i don’t have idea where and what to change

The selector is passing same in all the three scraping areas. DO this

  1. select three scraping wizards and compare the selectors , you will understand where can you change @Karthik_Kulkarni :slight_smile:

only IDX value is changing ,for 3 different scarpping different values am getting,

so with that can i do something

Can you try, once the first data is written into excel, then make the value as null or nothing. Then try to scrape the data from second. @Karthik_Kulkarni

sorry , i don’t have idea on selectors, could you please tell me how to make it null.

Not the selector @Karthik_Kulkarni, whatever the variable you are using to store the scraped data, assign it back to nothing… and then try

i will tell you one use case
i need to get the data of any product from flipkart or big basket across 3 locations.

can u send me the or show how to use dynamic selectors in data scraping

Hi @HareeshMR

I tried with clearing data table but it didn’t worked, i will attach my file can u help mebigbasket.xaml (57.5 KB)

Are you sure the page is typing the next name in the city datatable @Karthik_Kulkarni?

If so, try using assign activity as extracteddatatable = nothing instead of clear data table

yeah it is typing the next city name.

i tried with assign actvity (extracteddatatable = nothing instead of clear data table)
but am getting error

Are you getting the same error or anything new @Karthik_Kulkarni?

when i given assign activity as

datavariable=nothing(this is ok)

datavriable=nothing instead of clear data table(here am getting error as expresssion expected)

You don’t need to use clear data table.
Post the screenshot of your workflow

Hi @HareeshMR,

As shown in the below screenshot

1)I took small activity like going to web site ,typing the location name and searching with the product name followed by