Multiple tables across multiple URLs

How to?
#1

The website I am scraping uses the same format to present their info across numbered URLs, eg: www.example.com/12/test (it continues through 13, 14, 15 etc.)

Each page can have anything between 1 and 5 tables. The problem is that each table does not have column headings. The first thing at the top of the table is the first item. Another problem is that each table has the same name in the HTML.

If I set up a site map for one table on one URL, it works perfectly. However, when I try to expand it to multiple tables and use the numbered URL sitemap (www.example.com/[1-200]/test), it all goes wrong giving me multiple duplicate columns and lots of null values.

Here is the URL I have been working from: https://dashboard.onpremisewine.com/restaurants/12/wines

I have tried multiple different versions of the sitemap using text, html, elements, tables, but I cannot get it right.

Please assist if you can.

Cheers and thanks.

#2

Without seeing the larger page, it's hard to know what you want.

However try this

Element Select (Multiple) .wine
inside element select (as child use the following text selectors

Name =.name
Vintage =.vintage
Location =.grapes

Let me know if that works.

#3

You're a genius!

Works like a charm, even when I expanded it to search across multiple URLs.

Thank you!