I’m having difficulties with extracting a structured datatable from a website and then filtering out a certain value from the fifth column. Once having filtered I would like to choose the row with the newest value from column three but finally assigning the value from the first column in that row to a variable.
The website i’m scraping is:
Table from a drop-down list named: “Gögn úr ársreikningaskrá”
Steps I’m trying to take are:
-Extract Structured Data
-Assign filtered table (Column 5, by value “Ársreikningur”) to a new datatable
-Assign value from column 1 to a variable, based on the newest value from column 3
Could anyone point me in the correct direction with the VB expressions needed in the Assign activities?
Please let me know if there is further information needed.