5 Replies Latest reply: Mar 19, 2017 7:23 AM by Stefan Wühl RSS

    how to create a new column based on multiple columns values in script?

    Anat Dagan

      Hi,

      I have a table of student grades with 3 columns according to levels: beginner, intermediate and advanced:

          

      student idbeginner intermediateadvanced
      190
      2 80
      3 90
      4 40
      5100

       

      I would like to create a new column named "level" that will indicate student's level and another column that will gather up all the grades as follows:

         

      student idlevelgrade
      1beginner90
      2intermediate80
      3advanced90
      4intermediate40
      5beginner100

       

      How do i do that directly in the script?

      Thanks in advance!