Data extraction - Sample 1

The website features over 2,700 custom functions, each with dedicated information across six fields. Only one function is displayed at a time, and search is based solely on the website's functionality, with no offline access available.

Solution:
Each function has a unique URL with its ID, allowing the creation of an Excel row for each function. An extraction query loops through all rows, storing and cleansing the data in separate cells. This setup enables offline access and more detailed search capabilities.

Previous
Previous

Classification of construction materials

Next
Next

Data extraction - Sample 2