5 Replies Latest reply: Mar 22, 2014 5:10 PM by Marco Wedel RSS

    How to create a new column of data based on other columns (in the script)

      Hello,

       

      I was hoping someone could help with the following:

       

      I have attached sample data in an Excel file to show what I'd like to do.

       

      I have a set of files (about 20,000 rows worth) with four columns for four different staff shifts (First_Shift, Second_Shift, Third_Shift and Fourth_Shift).  Each column only has "data" (in text form) denoting if a staff member was utilized during that shift for that particular file date.  If no staff was used, then the cell is left blank.

       

      I would like to create an additional column that would aggregate all four shifts and total the number of "staff" used for that row (file date); each cell with content just means one staff member for that shift.

       

      I would also like to see if this could be done on the load script.

       

      Thank you in advance for the help!

      Karen