Challenge for the Parabola community! I’ve been trying to wrap my head around this and trying to find the right workflow, wondering if someone out there has any ideas.
(fake data for simplicity)
I have 100 users and 1000 jobs. Each user is either a cook, dishwasher, or waiter. I have jobs in all three categories. Is it possible to pick the top highest paying jobs from each category, then send each user the top 3 paying jobs (in their category) via an email?
Lets say both data sources are csv
The data I have for the users:
name, email, category
The data I have for the jobs:
category, pay, link to apply
The part I get stuck on is
- filtering the 100 jobs to only have the top 3 highest paying per category
- combing that data into new columns for the users table via some type of join (ideally the new users table would new columns like “Job1, Job2, Job3”)
The part I’m conformable with would be finishing that flow with a sendgrid destination and importing an html template + adding the merge tags from the newly created users table.
What do you think? Any idea how to solve this? Thank you!