Scraping City/District/Neighborhood

Help
1

Hi,

I’m trying to do a web scraping. Data should be stored in excel in this format.

City/District/Neighborhood

I have districts url’s. When you go to the url there are 5 neighborhood in that window like a table. I can get those neighborhood in a for each row with data scraping. But i can’t tag which neighborhood is in which district.

This is for each row activity which i’m getting neighborhood names.

Screenshot_5
Screenshot_5446×614 13.5 KB

Every iteration for data scrape i am getting 5 neighborhood name.

So how can i make like this in EXCEL as follows;

Spain,Madrid,Alcobendas
Spain,Madrid, Alcorcón
Spain,Madrid, Ajalvir
Spain,Madrid, Batres
Spain,Madrid, Brunete

Thanks for any help.

2

Use build data table activity to build a new data table with three columns.
In the for each loop, add a row to a data table with the saved values in three variables (City, District, Neighbourhood)

Pseudo code:

  1. Build data table with three columns
  2. For Each loop, add row with three values to a data table

Regards,
Karthik Byggari

1 Like