7 Replies Latest reply: Mar 1, 2016 4:51 PM by Mark Graham RSS

    Flag in If condition with 'Not Exists' functionality

    Mark Graham

      Hi All,

       

      I was trying to create a flag which distinguishes special and normal orders.

       

       

      Order,  Product, INS

      12345   ABC       Y

      12345    DEF      Y

      12345     GHI

      12345     JKL

      67891    TYU

       

      If an order has atleast one INS specified then it by default becomes special type and give 'Y' .

      Only if the order has no INS, then give 'N'.

       

      O/P:

       

      Flag Y has only 12345

      Flag N has only 67891

       

       

      Any help is highly appreciated.