Dynamic segmentation + Arcpy

Question

Item IDBegin EndTestDateConstruction1000011998200010010520012000100214199820001003451998200010043520052000

Requirments include:-

- I would like to segment the dataset to eliminate records with older TestDate to Construction date

- Output table should be non overlapping (begin/end)

Should look like below:-

Item IDBegin EndTestDateConstruction100103200120001004352005200010025719991998

Thanks

blake.terhune · Answer

This appears to be a duplicate post. The other thread has more responses.

Dynamic segmentation with respect to a control factor

JaiSiva1 · Answer

Hi Chukwuemeka,

From the comparing the input table and output table , it is hard for me to find a condition using which the      output table is generated.

If you can explain the condition & logic involved in detail , it will be helpful.

ChukwuemekaEzeiruaku · Answer

Thanks so much for the code, i was able to get that part done.

Is there a way either with python scripts or other solution to segment the following table to get the result below?

Input table (not a feature class)

Item IDBegin EndTestDate10000119981001052001100217199910034519981004352005

Each segmented section (from-to) should have all the item numbers written to a field that is within a certain range. From the input table, the final table should look like the one below:

Output table

Begin EndTestDateItem IDItem ID0119981000100113200110011001; 100234199910021001; 1002; 100445199810031001; 1002; 1003; 100457200510041002

Again Thanks.