1 Reply Latest reply on Mar 16, 2017 6:56 AM by lenaic.ridinger

    Set Candidate Calculated Field

    Alex Marlow

      Hi All,

       

      I was working with some miss matched data that did not include all of the candidate's IDs. I have joined two data sets and tried to then set the Candidate ID for all so that when I join another data source, I will have all of the candidate IDs mapped.

       

      My Calculated field is not quite working correctly because I am still receiving some NULL values in the set Candidate ID. I would also like to some how group all the same candidate IDs together. I have some candidates that are the same candidate, their name was just entered differently in the data.

       

      Please let me know if you have any questions. My workbook is attached.

       

      Thanks for your help!