6 Replies Latest reply: Jul 18, 2012 4:56 AM by Joe Kirwan RSS

    Create flag in load for max value in dim B for each value in dim A

    Joe Kirwan

      Hi

       

      I want script to create flag to show the max value in dim B for each value in dim A, as highlighted below:

       

      dim A

      dim B

      Val

      Flag

      x0001

      1

      1000

      0

      x0001

      2

      1000

      0

      x0001

      3

      1000

      0

      x0001

      4

      1000

      0

      x0001

      5

      1000

      1

      x0002

      1

      750

      0

      x0002

      2

      750

      0

      x0002

      3

      750

      0

      x0002

      4

      750

      1

      x0003

      1

      1100

      0

      x0003

      2

      1100

      1

       

      Rgds

       

      Joe