9 Replies Latest reply: Dec 30, 2016 5:23 PM by Onno van Knotsenburg RSS

    Flag creation in data load editor?

    Juna Sharma

      Hi all ,

      I have two fields DSI , open orders and report metric key. The condition for flag creation is DSI< 14 and open orders =0, and report metric key 4 or 5, What should be the expression like?

       

      I tried below expression but getting error in data load editor..

       

      if( report_ metric_ key=4 or report_ metric_ key=5,

      if(DSI<14 ad open_ orders=0,'14 DSI' &'_'&'0 open_orders')) as DSI_open_orders,

       

      Thanks

      Juna