3 Replies Latest reply: Nov 15, 2013 3:52 PM by Clever Anjos RSS

    Combining data from like fields into one field

    Nate Schroeder

      My data source has three fields that have the same type of data.  They were split into three fields because our database UI does not have a multiple selection option for names.  This allows the user to select multiple people (up to three).  Let's call them Employee_1, Employee_2 and Employee_3.


      I would like to add code to the load script to combine these fields into one Employee field.  I have thought about perhaps concatenating the fields into one, then using the Subfield function, but this seems messy and I end up with extra separators when there are blank fields.


      Is there a simple way that fields can be joined?


      I appreciate any suggestions you may have.