6 Replies Latest reply: Apr 8, 2014 6:12 AM by Ridhaa Hendricks RSS

    Creating new columns

    Ridhaa Hendricks

      Please could you assist

       

      I have  two tables, each table has a field called GROUPNAME.

       

      [Open Cases]:

      SerialNoOPEN,

      GROUPNAME,

      AGENTNAME,

      DATE

       

      [Closed Cases]:

      GROUPNAME,

      DATE,

      SerialNoCLOSED

       

      I need to create a new column using one of the items in the "GROUPNAME" field

      I need to count the serial number for all

       

      Load*,

      Count(If(match(GROUPNAME,'VAS'),SerialNoOpen)) as VASOPEN

      resident [Open Cases]

      Group by

      SerialNoOPEN,

      GROUPNAME,

      AGENTNAME,

      DATE

       

      I then need to get the Count of the Closed case serial numbers for VAS as well