5 Replies Latest reply: Aug 16, 2013 9:19 AM by BRIJESH GADHESARIYA RSS

    Flag Creation in script

    BRIJESH GADHESARIYA

      Hi all,

       

      I wanted to create a flag at script level.
      My data is like this:
      Load * inline
      [
      AppNo, Date
      123, 12/11/2013
      123,
      124,12/10/2012
      124, 10/05/2012
      125,
      125
      126,10/12/2012
      ];

       

      There are multiple dates against a single AppNo, I wanted to create a flag against AppNo. if any one Date is null against AppNo, then Flag=N else Y

       

      So my output should be like this:

       

      AppNo, Date, Flag
      123, 12/11/2013, N
      123,                  ,N
      124,12/10/2012, Y
      124, 10/05/2012, Y
      125,                  , N
      125                  , N
      126,10/12/2012, Y

       

      Your help is valuable to me. . .

       

      Best Regards,
      BRIJESH