After After Data Scraping i need to seperate data based on a category and store them in seperate Excel sheets


#1

I need to scrap data from a site where we have data related to two categories like buildings and Agriculture land.So,after Data scrap how to identify the category and copy the data into different sheets in Excel.


#2

you can create datatable from data scrapping, the created datatable you can use condition based on your requirement to filter data like building and agriculture.

the resulting filter data you can write to corresponding excel file using write range or append range excel activity

thanks