6 Replies Latest reply: Oct 3, 2017 5:43 AM by Bill Markham RSS

    Adding multiple values to a field

    Wai Meng Leong

      Hi all,

       

      I have two columns namely ZMERGE and SUBJECT GROUP. (table 1)

      I have another table with ZMERGE values which refers to table 1 to give me subject group of the user: (table 2)

       

      Table 1:

      ZMERGESUBJECT GROUP
      CHChemistry
      LSLife Sciences
      MDMedical Sciences
      PSPsychology

       

      Table 2:

      NAMEZMERGE
      JohnCH
      PeterLS
      BarryMD
      FrankCH, LS, MD, PS

       

      How do I, in the load script write in a value for SUBJECT GROUP call MULTIPLE_SUBJECTS so that for people like Frank (with multiple values in ZMERGE, they will have a proper value in SUBJECT GROUP?

       

      (Also, the actual list is long so we can't just code in CH, LS, MD and PS).

       

      Thank you in advance for all help!

       

      Regards,

      Wai Meng