Dynamic segmentation with respect to a control factor Additional Requirements

[ChukwuemekaEzeiruaku]

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:

Data	UniqueID	Item ID	Begin	End	Input Table
Observation1	555	1000	0	1
	555	1001	0	5
	555	1002	1	7
	555	1003	4	5
	555	1004	3	5
Observation2	600	2001	0	3
	600	2002	2	6
	600	2003	3	5

Data	UniqueID	Begin	End	Item ID	Output Table
Observation1	555	0	1	1001
	555	1	3	1001; 1002
	555	3	4	1001; 1002; 1004
	555	4	5	1001; 1002; 1003; 1004
	555	5	7	1002
Observation2	600	0	2	2001; 2002
	600	2	3	2001; 2002
	600	3	5	2002; 2003
	600	5	6	2003

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.

[ChukwuemekaEzeiruaku]

i see, yea there are a few missing data for dates

[BlakeTerhune]

Is that a data cleanup issue or does the code need to accommodate missing dates?

[ChukwuemekaEzeiruaku]

it's not a clean up issue, the data is expected to have missing data..

It'll be nice to have the code to accommodate for missing dates...

[ChukwuemekaEzeiruaku]

If the dates will be a pain i'll suggest we kill it and make the output table to include just the UniqueID, Begin and End, SegmentItems

[BlakeTerhune]

I updated the code to accommodate missing dates. Attached is the updated code and copy of the output table. I did brief review of the output and there doesn't seem to be any duplicate segments. The only possible issue I see is that it is creating segments that do not have an ItemID. This is because there is a gap in begin and end values. See UniqueID 1446100 for an example.

[ChukwuemekaEzeiruaku]

Awesome Thanks, but there is no attachment to your reply

[BlakeTerhune]

You don't see this?

[ChukwuemekaEzeiruaku]

Nope, i can see just the text and not the attachments..

[BlakeTerhune]

Check out Re: Some users unable to get attachments.

Timothy Hales said:

Make sure you open the discussion up and are not viewing it in your Inbox or Activity Stream.

[ChukwuemekaEzeiruaku]

I can't find any discussion button in the page