The JoinResult option in scraping agent fields are used to join the multiple results of a selector into a single delimited string. For example, if you are scraping a product website, and the product page displays multiple categories, sizes, images or variants. The scraping agent will display each result in separate row by default, and we can use the
JoinResult option to combine them all into a single cell to make our data table as one-product-one-row.
The result of the field can be separated by a specified delimiter, provided using the PostProcessing parameter (
JoinDelimiter) and its default value is comma(, ).
If we see this product page screenshot, the product has the category as Home > Books > Poetry and then the book name. And using the
.breadcrumb a selector extracted 3 matches in separate rows, while we have product_name and price on 1st row.
- Edit the scraping agent by clicking on the "Edit" tab
- Go to the field you wants to join. In this case Category and then enable the
- Then "Save" the scraping agent configuration
- And finally re-run your scraping agent to apply the changes.
After re-running the agent, you'll see that the field result will be joined in single cell as in screenshot below for Category.