Clay Icon

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. 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. 2.

    Display this information in Table B alongside the corresponding company.

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