4 Replies Latest reply: Jul 14, 2017 7:42 AM by praveen A RSS

    Calculated column in resident

    Axel Vazquez

      Hi, I need help with doing this

       

      I have this table :

       

      Example:

       

      LOAD

       

      id,

      group,

      date,

      sum(cant) as Cant,

      sum(days) as Days

       

      FROM ...

      group by id, group, date;

       

      Before this, i have three concatenates which add 3 new values.

       

      and after that, i have to add new columns based in these previous values, so i use "resident"

       

      Load

       

      id,

      group,

      date,

      sum(concatenate_value1) as concat1,

      sum(concatenate_value2) as concat2

      sum(concatenate_value1 + concatenate_value3) as concat 3

       

      resident example

      group by group by id, group, date;


      But this isn't working, any idea with this ??


      thanks !!