Filter information in Excel

Dear ones, I need to make a filter that takes only specific cities and shows only those in an Excel spreadsheet. I can already create the spreadsheet and extract all the data from the table of a web page, but I don’t know how to do it to filter only the cities I want. can you help me? I tried to do it that way, but I can’t finish it and I don’t know if it’s correct either. Thank you!

Hi @KarinaFreitas

You can use the filter datatable activity to filter the datatable based on the values you need.

The other approach is to use the assign activity and use datatable.select method to filter.

YourDataTable.Select("City='city'")