4 Replies Latest reply on Sep 25, 2016 11:07 PM by Hima vardhan Reddy Pavuluri

    finding unknown gender from secondary source

    Sherzodbek Ibragimov

      Well, I have a quite few empty fields for gender. I compiled a gender database from a different sources based on first names (I know it is not a 100% accurate method still, but it is better option compared to having empty fields), where I would like to use gender if first in original source is equal to first name in secondary source. Unknown is not a NULL, it is 'Unknown'. FYI.  Here is what I mean

      My original source   

      IDNameGender
      1AlexMale
      2LizaFemale
      3AlisonFemale
      4EricMale
      5AdamUnknown
      6BruceUnknown
      7JuneUnknown

       

      Secondary source:

       

      NameGender
      AdamMale
      BruceMale
      JuneFemale

       

      I have tried calculated field, but no luck so far. Any idea how to handle this? Thank a lot.