How to Extract Job Offers by Company from Two Tables

Hi Team, I need help with a task involving two tables: Table A, which contains job offers, including a column named "1A," and Table B, which lists companies. I would like to achieve the following:

1.
Extract the number of job offers in Table A that are associated with a specific company and meet a condition based on one of the values in column "1A."
2.
Display this information in Table B alongside the corresponding company.

Could you please guide me on how to implement this? Thank you!

2 comments

Tomi F.
·
·
Hello Katarzyna! Do you mind sending the links to the tables so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1731945600&signature=b5a502c87db275f3871ba65e9cb9e0fa8a1d3085c0b84dd3c1080d92198ad900&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr1ApIQ2BKsam%2FhVPsUDg%3D%3D%0A Without looking at the tables, I am thinking this can be done using a lookup enrichment from table B to table A. If we use 'lookup multiple rows', we should be able to pull the number of rows found.
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.