Data integrity when pulled (data not properly attributed to column)

[66north]

Describe the problem.
Incomplete data pulled, some data is not in appropriate columns.

Any help is definitely appreciated.

Sitemap:
{"_id":"thorne_dealer_v2","startUrl":["https://www.thorne.com/find-a-health-professional"],"selectors":[{"id":"city_v2","type":"SelectorLink","parentSelectors":["_root"],"selector":"p a","multiple":true,"delay":0},{"id":"name_v2","type":"SelectorText","parentSelectors":["city_v2"],"selector":".professional-result div.column:nth-of-type(n+2) > div","multiple":true,"regex":"","delay":0},{"id":"profession","type":"SelectorText","parentSelectors":["city_v2"],"selector":"div.column:nth-of-type(2) > div:nth-of-type(n+2)","multiple":true,"regex":"","delay":0},{"id":"address","type":"SelectorText","parentSelectors":["city_v2"],"selector":"div.column:nth-of-type(3) div","multiple":true,"regex":"","delay":0},{"id":"phone","type":"SelectorText","parentSelectors":["city_v2"],"selector":"div:nth-of-type(4) div.is-bolded","multiple":true,"regex":"","delay":0},{"id":"website","type":"SelectorText","parentSelectors":["city_v2"],"selector":"a:nth-of-type(n+2) div:nth-of-type(4) div:nth-of-type(2)","multiple":true,"regex":"","delay":0}]}

[leemeng]

Your scrape was not structured correctly and would generate unpredictable results. I have restructured your data scrapers - placed them in a parent selector and disabled the Multiple option (the parent selector already has Multiple). This should work now:

{"_id":"thorne_dealer_v3","startUrl":["https://www.thorne.com/find-a-health-professional"],"selectors":[{"id":"city_v2","type":"SelectorLink","parentSelectors":["_root"],"selector":"p a","multiple":true,"delay":0},{"id":"name_v2","type":"SelectorText","parentSelectors":["listing_selector"],"selector":"div:nth-of-type(2) div.is-bolded","multiple":false,"regex":"","delay":0},{"id":"profession","type":"SelectorText","parentSelectors":["listing_selector"],"selector":"div.column:nth-of-type(2) > div:nth-of-type(n+2)","multiple":false,"regex":"","delay":0},{"id":"address","type":"SelectorText","parentSelectors":["listing_selector"],"selector":"div.column:nth-of-type(3) div","multiple":false,"regex":"","delay":0},{"id":"phone","type":"SelectorText","parentSelectors":["listing_selector"],"selector":"div:nth-of-type(4) div.is-bolded","multiple":false,"regex":"","delay":0},{"id":"website","type":"SelectorText","parentSelectors":["listing_selector"],"selector":"a:nth-of-type(n+2) div:nth-of-type(4) div:nth-of-type(2)","multiple":false,"regex":"","delay":0},{"id":"listing_selector","type":"SelectorElement","parentSelectors":["city_v2"],"selector":"a div.professional-result","multiple":true,"delay":0}]}

[66north]

Thank you! This is a huge help.