Forum Discussion
Creating Relationships & Matching - Need some help
Hi sokatenaj,
Additionally on my applicant table I have a field I that says "current status name" with a field that says "Linked". I want to say, if 'Applicant'[Name] that have a status of 'Applicant'[Current status name]="Linked" and that Applicant Name matches the name in 'Filled'[Name] then write MATCH, otherwise "Not Matched".
If I understand you correctly, you should be able to use the formula below to create a new calculate column in this scenario. :smileyhappy:
Column = IF ( Applicant[Current Status Name] = "Linked" && CONTAINS ( Filled, Filled[Candidate Identifier], Applicant[Candidate Identifier] ), "Match", "Not Matched" )Regards
Hi sokatenaj,
Could you post your table structures with some sample/mock data, and the expected result against the data? So that we can better assist on this issue? :smileyhappy:
Regards
Hi v-ljerr-msft,
Here you go. As a reminder, I cannot create a relationship because the candidate name and candidat identifier in the applicant table can show up 10 times if they applied to multiple jobs. So I need to think of a different way to validate that there is a "match". Hope this helps. Thanks so much!!!
Applicant Table
Job ID Name Candidate Identifier Posting Title Department Number Department Name Recruiter Name Hiring Manager Name Current Req Status First Fully Approved Date Latest Cancelled Date Latest Filled Date Current Step Name Current Status Name 3042478 Mouse, Mickey 124555 Cartoon Character CART123 Disney Disney, Walt Blah, Blah Approved 6/28/2017 Open New 5448848 Duck, Daisy 128487 Cartoon Character CART222 Forest Disney, Walt Blah, Blah Approved 6/28/2017 Open Awaiting Response - Email 6545644 Duck, Darkwing 585456 Disney Dude CART124 Disney Disney, Walt Blah, Blah Approved 6/28/2017 Open Linked 5998895 Chipmunk, Alvin 868677 Music Dude CART222 Seville Bagdasarian, Ross Ha, Blah Approved 6/28/2017 Open Awaiting Response - Email 3042478 Duck, Darkwing 585456 Disney Dude CART124 Disney Disney, Walt Blah, Blah Approved 6/28/2017 Open Awaiting Response - Email Filled Table
Job ID Name Candidate Identifier Posting Title Recruiter Name Hiring Manager Name Current Req Status First Fully Approved Date Latest Cancelled Date Latest Filled Date Current Step Name 1000877 Mouse, Mickey 124555 Cartoon Character Disney, Walt Blah, Blah Filled 6/28/2017 7/2/2017 Offer Accepted 8878787 Duck, Darkwing 585456 Chipunks Band Disney, Walt Blah, Blah Filled 6/28/2017 7/2/2017 Offer Accepted Hi sokatenaj,
Additionally on my applicant table I have a field I that says "current status name" with a field that says "Linked". I want to say, if 'Applicant'[Name] that have a status of 'Applicant'[Current status name]="Linked" and that Applicant Name matches the name in 'Filled'[Name] then write MATCH, otherwise "Not Matched".
If I understand you correctly, you should be able to use the formula below to create a new calculate column in this scenario. :smileyhappy:
Column = IF ( Applicant[Current Status Name] = "Linked" && CONTAINS ( Filled, Filled[Candidate Identifier], Applicant[Candidate Identifier] ), "Match", "Not Matched" )Regards
