Data Scraping from web page based on particular criteria

For example the criteria is to scrap data(commodity name, LastPrice) from “Commodities Futures Prices & Day Charts - Yahoo Finance” only if commodity name is “Gold”.

Tried to modify data scraping selector like this

<webctrl tag='tbody' />
<webctrl tag='TD' aaname='Gold'/>

But it’s not scraping data,
The ExtractDataTable is coming as null.

Only <webctrl tag='tbody' /> is working fine, but scraping all of the records irrespective of the commodity name.

If Data scrap is empty means extract data is not extracting data from the web page

Please check the codes I have used here, previously it was not coming in the post.

@desmond00 Check attached file i hope this is the solution

YahooFinance.xaml (13.0 KB)

@indra thanks for the solution. That way I have already did it, but it is taking the whole data first in extractDataTable then filtering that thing I did not wanted. I wanted to select those commodity name specific data only during the data scraping. Anyway it seems that is not possible.
Thank you for your time. :grinning: