https://community.esri.com/t5/arcgis-pro-questions/collapse-records-in-standalone-table-model-builder/m-p/1279650#M68091 <P>Using ArcGIS Pro 2.9.5 Advanced and file geodatabase for all data workspaces.</P><P>I have a model built using an iterator to perform various geoprocessing on input polygon geometry*, where the goal is output in a table where each row contains beginning and end x/y coordinate pairs, which will be used elsewhere outside of the model to create line features.</P><P>Following geoprocessing of the input shapes, I'm perform four Sort functions on a table to get the minimum or maximum value for a specific field, then a Get Field Value to capture that first record from the sort for each of the four Sorts.&nbsp; This is where I get stuck: I'm currently using the Get Field Value results, followed by Collect Values and exporting those results to separate tables, then merging the four tables together.&nbsp; The result is close to what I need, but I need to dissolve the records together but am not sure how with a standalone table.</P><P>Because this is within an iterate, ideally I could just use the four Get Field Values and use those to calculate fields in another table (where each iteration calculates on the same record) - but I cannot figure out how to do that.&nbsp; Perhaps I'm approaching this wrong altogether, or perhaps there's a way to use Pandas to dissolve/melt the merged table output...I'm stuck.&nbsp; Any help would be appreciated.&nbsp; Thanks</P><P>*I am manually merging parcel data together by PLSS section, and then using this model builder process to create PLSS quarter section lines based on the geometry of the merged parcels.&nbsp; The model builder iteration is to perform the various geoprocessing section-by-section.&nbsp; The desired result is for cleaner cartographic displays where at least the section lines and parcel boundaries are coincident.&nbsp; So far this model is only focused on the West-East quarter section lines.&nbsp; If I can get it working I'll expand it to also create South-North lines as well.</P> Tue, 18 Apr 2023 13:44:46 GMT JustinWolff 2023-04-18T13:44:46Z https://community.esri.com/t5/arcgis-pro-questions/collapse-records-in-standalone-table-model-builder/m-p/1279650#M68091 <P>Using ArcGIS Pro 2.9.5 Advanced and file geodatabase for all data workspaces.</P><P>I have a model built using an iterator to perform various geoprocessing on input polygon geometry*, where the goal is output in a table where each row contains beginning and end x/y coordinate pairs, which will be used elsewhere outside of the model to create line features.</P><P>Following geoprocessing of the input shapes, I'm perform four Sort functions on a table to get the minimum or maximum value for a specific field, then a Get Field Value to capture that first record from the sort for each of the four Sorts.&nbsp; This is where I get stuck: I'm currently using the Get Field Value results, followed by Collect Values and exporting those results to separate tables, then merging the four tables together.&nbsp; The result is close to what I need, but I need to dissolve the records together but am not sure how with a standalone table.</P><P>Because this is within an iterate, ideally I could just use the four Get Field Values and use those to calculate fields in another table (where each iteration calculates on the same record) - but I cannot figure out how to do that.&nbsp; Perhaps I'm approaching this wrong altogether, or perhaps there's a way to use Pandas to dissolve/melt the merged table output...I'm stuck.&nbsp; Any help would be appreciated.&nbsp; Thanks</P><P>*I am manually merging parcel data together by PLSS section, and then using this model builder process to create PLSS quarter section lines based on the geometry of the merged parcels.&nbsp; The model builder iteration is to perform the various geoprocessing section-by-section.&nbsp; The desired result is for cleaner cartographic displays where at least the section lines and parcel boundaries are coincident.&nbsp; So far this model is only focused on the West-East quarter section lines.&nbsp; If I can get it working I'll expand it to also create South-North lines as well.</P> Tue, 18 Apr 2023 13:44:46 GMT https://community.esri.com/t5/arcgis-pro-questions/collapse-records-in-standalone-table-model-builder/m-p/1279650#M68091 JustinWolff 2023-04-18T13:44:46Z