Extract data from website

Help
6

Hi @bhe98

The initial extraction using data scraping will extract some unwanted data as well. The workflow provided by @Navneetj3 shows it clearly… The initial extraction creates some unwanted data. However, after the filter he has applied, it filters the required dataset for you.

I tweaked @Navneetj3’s same workflow a bit to add the data to a excel file. It adds the full extracted list to a separate sheet, and the filtered list to another sheet which clearly shows the expected result.

Edit: one thing I forgot to say is, the reason for the data scraping to extract some unwanted stuff is because of the structure of the table in the web page. It has some merged cells and some rows are considered as a merged row. I identified that by trying to do scraping for one column. However, filtering it gives you the expected result

dailyfx.xaml (9.1 KB)

1 Like