4 Replies Latest reply: Sep 6, 2012 7:42 AM by valerydetez RSS

    acces variable in inline object

      hello

       

       

      here is my code

      threshold:

      LOAD * INLINE [

      key, warningv, errorv

      'test1', 6500, 7000

      'test2', 3000, 4000

      'test3', 2500, 2000

      ];

       

       

      testtable:

      inner join(threshold)

      LOAD 'test1' as key,

           @1 as timetest1,

           @2 as s2,

           @3 as s3,

           @4 as s4,

             @2+@3+@4 as mysum,

           if (@2+@3+@4 < warningv ,'green', 'red' ) as availability

      FROM

      ....

       

      With warningv it does not work, how can I user variable in order to compare @2+@3+@4 with 6500 (value of warningv in test1 from threshold table)?

       

      thks

       

      valery