Logoc Question - Looping
Posted: Thu Dec 17, 2009 7:44 am
I have a requirement to produce multiple records from one input.
i.e. ColA ColB Low High
EE AA 10 12
My requirement is to end up with the following
EE AA 10
EE AA 11
EE AA 12
For each input I must create multiple records that fall between the low and high of the input record. I tried using a range lookup but I can't seem to figure out how to add to my counter.
Has anyone designed logic using DS or must I create a BuildOp
Thanks in advance
i.e. ColA ColB Low High
EE AA 10 12
My requirement is to end up with the following
EE AA 10
EE AA 11
EE AA 12
For each input I must create multiple records that fall between the low and high of the input record. I tried using a range lookup but I can't seem to figure out how to add to my counter.
Has anyone designed logic using DS or must I create a BuildOp
Thanks in advance