3 Replies Latest reply: Feb 13, 2017 9:18 AM by Marcus Sommer RSS

    Matching Missing Field Values

    Salamon Musayev

      Hello,

       

       

      I have two field in the data load editor.   One field has the name of employees and the other has there respective title.

       

      There are few employees who are missing titles. 

       

      I wanted to know if there is a way I can match or fill in their title in the data load editor.

       

      For example.

       

      EmployeeName                     EmployeeTitle

      Name1                                   RN

      Name2                                   Physician

      Name3

      Name4                                   LPN

      Name5

      Name6                                   Janitor

       

      I know that Name3 is an RN and Name 5 is a Janitor.  Is there a way I can match them to their respective titles.

      I could do an if statement like the following

       

        if( EmployeeName   = 'Name3' , 'RN', EmployeeTitle) as "EmployeeTitle,

       

      I wanted to know if there is a more effecient way of doing, maybe like mapping or something.  I have several users with that issue and I would rather not right if statements as I am afraid it may impact performance.

       

      Please help.

       

       

      Thank you in advance.