Bojan

❤️ you long time found it at the bottom right

cause tomorrow jobs data will come in, odds are there will be 1 company hiring multiple roles, and that would automatically get written as duplicate entries into my company table

Sure, that’s manual though, i should have been specific, is there a way to dedupe automatically

this is my workbook So you can see if i have duplicate Companies, it manifests into duplicates everywhere downstream

nice one Eric N. i also do that, in the main jobs table, i basically Count, how many job postings that company has Quick Q - As im continuously getting new job data into the table - is there a way to automatically Dedupe this data when i extract it into a Company Table?

haha

dude i just figured out what you were saying

this is kinda what i’ve done but its not working for me https://www.tella.tv/video/bojans-video-2lm0

yeah already did that 🙂 but a company can have multiple different job titles, so its not like all of them are the same, with this recommendation of yours and how i’ve done it, i’d have to create new tables in Clay, for each distinct job title, and that way, i could use the multiple lookup table function correct? this is why i really need a group by feature haha