Is there a way either with python scripts or other solution to dynamically segment a table with linear measures (from-to fields) Each segmented section (from-to) should have all the item numbers written to a field that is within a certain range. e.g:
Input table
row1. A-----c ===> itemID =1400
row2. B-----F ===> itemID =1401
row3. D-----F ===> itemID =1402
Output Table
row1. A-----B ===> itemID =1400
row2. B-----C ===> itemID =1400; 1401
row3. C-----D ===> itemID =1401
row4. D-----F ===> itemID =1401; 1402
Note: the input table is just a dbf file...