emeka.ezeiruaku

Re: Dynamic segmentation with respect to a control factor Additional Requirements

Discussion created by emeka.ezeiruaku on May 8, 2015
Latest reply on Aug 8, 2016 by blake.terhune
Branched from an earlier discussion

I was able to figure out the error from earlier, but i have one more request.

If i have other fields in the table i want to also show on the out_table for example see table below:

 

   

DataUniqueIDItem IDBegin EndInput Table
Observation1555100001
555100105
555100217
555100345
555100435
Observation2600200103
600200226
600200335

 

 

   

DataUniqueIDBegin EndItem IDOutput Table
Observation1555011001
555131001; 1002
555341001; 1002; 1004
555451001; 1002; 1003; 1004
555571002
Observation2600022001; 2002
600232001; 2002
600352002; 2003
600562003

Is there a way to differentiate between records that are within a certain range(with UniqueID) as shown in the table above, plus have other fields for that range (with same uniqueID) in the output table?

 

I am really grateful for your help thus far guys, Thanks.

Outcomes