Matching extracted data

How to?
#1

I'm trying to extract a name, number and website from thomsonlocal.com for a particular trade. I've run a test on one page and I've successfully extracted all three, the problem is, I first get a column of names, followed by a column of numbers and then web addresses.

I assume the first name corresponds to the first number but not every record has a website.

I can extract both name and number with a text selector but I need to grab the website with a element attribute selector with href.

So I'd like to know if it's possible to extract all three together as one record?

{"_id":"thomson","startUrl":["https://www.thomsonlocal.com/electricians/UK/?Page=2"],"selectors":[{"id":"name","type":"SelectorText","parentSelectors":["_root"],"selector":"h2.businessName","multiple":true,"regex":"","delay":0},{"id":"number","type":"SelectorText","parentSelectors":["_root"],"selector":"div.phoneCont","multiple":true,"regex":"","delay":0},{"id":"site","type":"SelectorElementAttribute","parentSelectors":["_root"],"selector":"li.listingHeadLink.website a","multiple":true,"extractAttribute":"href","delay":0}]}

#2

Hello there!

What you are trying to achieve can be done using an Element selector, to wrap all same-type elements (cards with info that go in a list), then all your fields will go within same row.

I've updated your sitemap:

{"_id":"thomson2","startUrl":["https://www.thomsonlocal.com/electricians/UK/?Page=2"],"selectors":[{"id":"name","type":"SelectorText","parentSelectors":["grouping"],"selector":"h2.businessName","multiple":false,"regex":"","delay":0},{"id":"number","type":"SelectorText","parentSelectors":["grouping"],"selector":"div.phoneCont","multiple":false,"regex":"","delay":0},{"id":"site","type":"SelectorElementAttribute","parentSelectors":["grouping"],"selector":"li.listingHeadLink.website a","multiple":false,"extractAttribute":"href","delay":0},{"id":"grouping","type":"SelectorElement","parentSelectors":["_root"],"selector":"li.listing","multiple":true,"delay":0}]}
Random Data - Help Needed
#3

That's brilliant, it works like a charm. Thank you.

Excellent, excellent app, well done.