Issues with table selector

image
Url: https://www.vanslingerlandt.com/bedrijf-database/
The table selector of my sitemap creates wrong table output due to the first 2 column's having 1 header.
The data below the headers is shifting one column and the correct data of the last column is missing.
I actually have no need to scrape "vergelijk" (is actually a link) but it now ends up below the "2021" header when scraped.
I can not figure this one out yet, being a newbie.
What would be a solution in order to get correct table output in the excel from the scraped data ?
I have tried to search for a solution but lacking the knowledge at this moment.
Thanks for getting me on track :wink:

@gekko Hello, you can discard the 'Empty' table rows by using the following 'Element' selector - tbody tr:has(.compare)

Example:

{"_id":"vanslingerlandt-com","startUrl":["https://www.vanslingerlandt.com/bedrijf-database/"],"selectors":[{"id":"wrapper","multiple":true,"parentSelectors":["_root"],"selector":"tbody tr:has(.compare)","type":"SelectorElement"},{"id":"name","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(1)","type":"SelectorText"},{"id":"2021","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(3)","type":"SelectorText"},{"id":"2020","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(4)","type":"SelectorText"},{"id":"2019","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(5)","type":"SelectorText"},{"id":"2018","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(6)","type":"SelectorText"},{"id":"2017","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(7)","type":"SelectorText"},{"id":"2016","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(8)","type":"SelectorText"},{"id":"2015","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(9)","type":"SelectorText"},{"id":"2014","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(10)","type":"SelectorText"},{"id":"2013","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(11)","type":"SelectorText"},{"id":"2012","multiple":false,"parentSelectors":["wrapper"],"regex":"","selector":"td:nth-of-type(12)","type":"SelectorText"}]}

@ViestursWS Hello, thanks so much for this great help. This has brought me forward enormously ! Thanks again for your very valuable help. :ok_hand: :+1: :clap: