1 Reply Latest reply on Jul 7, 2014 9:33 AM by Joe Oppelt

    calucluate field looking at if then in multiple names

    john.stjohn

      Hi, I am tyring to write a script as a calculated field that looks at four different columns of names and determines if a name appears in any of hte four columns:

       

      Here is a sample data set:

       

      DateClassReviewer ScoreInstructor 1 NameInstructor 2 nameInstructor 3 nameInstructor 4 name
      04/14/2014Regional Banking New Hire Orientation 82711724DUCRET, TIFFANY NICOLEPETERSEN, LAURA JARNEY, MARY CLEMLY, DAVID F
      04/14/2014Consumer Deposits Basics 8271524 Day 14DUCRET, TIFFANY NICOLEPOULIOT, ELIZABETH ARNEY, MARY CKOMINCZAK, DONNA L
      04/14/2014Consumer Deposits Basics 8271524 Day 15DUCRET, TIFFANY NICOLENGUYEN, QUOC ARNEY, MARY CCABALLERO, JASON MATTHEW
      04/15/2014Introduction to Small Business3HOANG, BAO NNGUYEN, QUOC ARNEY, MARY CCABALLERO, JASON MATTHEW
      04/15/2014Putting it Together for Tellers2BROWN, ELIZABETH ONGUYEN, QUOC ARNEY, MARY CBUCKNER, JENNIFER LEE
      04/16/2014Calling Basics3BROWN, ELIZABETH ONGUYEN, QUOC ARNEY, MARY CBUCKNER, JENNIFER LEE
      04/16/2014Approving Transactions4HODGES, SABRYNA LNGUYEN, QUOC ARNEY, MARY CGUEVARA, DIANA ELIZABETH
      04/16/2014Consumer Deposits Basics 8271524 Day 15HODGES, SABRYNA LNGUYEN, QUOC ARNEY, MARY CGUEVARA, DIANA ELIZABETH
      04/17/2014Consumer Deposits Basics 8271524 Day 15GUEVARA, DIANA ELIZABETHKLING, STEPHEN DUCRET, TIFFANY NICOLEARNEY, MARY C
      04/28/2014Regional Banking New Hire Orientation4GUEVARA, DIANA ELIZABETHKLING, STEPHEN DUCRET, TIFFANY NICOLEARNEY, MARY C
      04/14/2014Your Role as a Teller3BECKER Jr, JERRY ALANSMITH, ANDREWDUCRET, TIFFANY NICOLEARNEY, MARY C
      04/14/2014Military Status Affidavit4PETERSEN, LAURA JSMITH, ANDREWHOANG, BAO NARNEY, MARY C
      04/14/2014SmartStation 2.0 Overview2PETERSEN, LAURA JHODGES, SABRYNA LBROWN, ELIZABETH OGUEVARA, DIANA ELIZABETH
      04/15/2014WFHL - Wells Fargo and You an Introduction4PETERSEN, LAURA JHODGES, SABRYNA LBROWN, ELIZABETH OKLING, STEPHEN
      04/15/2014Military Status Affidavit2ARNEY, MARY CLEMLY, DAVID FHODGES, SABRYNA LKLING, STEPHEN
      04/16/2014Military Status Affidavit1ARNEY, MARY CKOMINCZAK, DONNA LHODGES, SABRYNA LSMITH, ANDREW
      04/16/2014Military Status Affidavit2ARNEY, MARY CCABALLERO, JASON MATTHEWLEMLY, DAVID FSMITH, ANDREW

       

      I'd like to be able to filter by a combination of instructor 1, 2, 3, or 4.  Each of those columns is a name so I want to create a field that will take a filter for example "Hodges, Sabryna L" as an instructor and display the score but instead of finding her as instructor 1 it will find her if she was any of the four instructors.