topic Compiling data from multiple feature classes/tables into one view in Data Management Questions https://community.esri.com/t5/data-management-questions/compiling-data-from-multiple-feature-classes/m-p/609239#M34313 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I'll start out by saying that I am running 10.2 on a Windows 7 machine.&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I have 6 layers, some of which are related.&nbsp; The related feature classes and table are as such:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Poles (point)</P><P>Hubs (point)</P><P>NodeAssociations (table)</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>The Poles and Hubs both have a 1:many relationship with the NodeAssociations.&nbsp; Ultimately I would like to attribute all three of these items, and then create some sort of way to view the data from all three in one place. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I know a join will accomplish this, but I really don't like the way a join places the secondary table at the end of your primary table.&nbsp; Additionally, I've been having issues with posting data from joined feature classes to the default version in my SDE environment. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Is there a way to pick and choose which fields you want to take from each feature layer, and then order them in the manner that you want to view them in?</P></BODY></HTML> Thu, 18 Dec 2014 20:09:35 GMT CoyPotts1 2014-12-18T20:09:35Z Compiling data from multiple feature classes/tables into one view https://community.esri.com/t5/data-management-questions/compiling-data-from-multiple-feature-classes/m-p/609239#M34313 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I'll start out by saying that I am running 10.2 on a Windows 7 machine.&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I have 6 layers, some of which are related.&nbsp; The related feature classes and table are as such:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Poles (point)</P><P>Hubs (point)</P><P>NodeAssociations (table)</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>The Poles and Hubs both have a 1:many relationship with the NodeAssociations.&nbsp; Ultimately I would like to attribute all three of these items, and then create some sort of way to view the data from all three in one place. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I know a join will accomplish this, but I really don't like the way a join places the secondary table at the end of your primary table.&nbsp; Additionally, I've been having issues with posting data from joined feature classes to the default version in my SDE environment. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Is there a way to pick and choose which fields you want to take from each feature layer, and then order them in the manner that you want to view them in?</P></BODY></HTML> Thu, 18 Dec 2014 20:09:35 GMT https://community.esri.com/t5/data-management-questions/compiling-data-from-multiple-feature-classes/m-p/609239#M34313 CoyPotts1 2014-12-18T20:09:35Z