https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-sort-on-join-field/idi-p/1473528 <P><EM>ArcGIS Pro 2.9.5; File Geodatabase:</EM></P><P>I have two standalone tables. I join them using Add Join, resulting in a 1:M join.</P><P>In the attribute table, I can't sort on the join table fields; the sort options are greyed out. Whereas the input fields are sortable.</P><P>Could the attribute table be enhanced so that sorting is supported on join fields when the join is 1:M?</P><P>Video:<BR /><BR /><div class="lia-vid-container video-embed-center"><div id="lia-vid-6353001723112w894h540r784" class="lia-video-brightcove-player-container"><video-js data-video-id="6353001723112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6353001723112w894h540r784'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6353001723112">(view in My Videos)</a></div><BR />For what it's worth, in 3.3.0, I don't have this problem if I specify that the join will be one-to-first in the Add Join tool. I only have this problem with one-to-many joins.&nbsp;</P> Wed, 22 May 2024 01:00:13 GMT Bud 2024-05-22T01:00:13Z https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-sort-on-join-field/idi-p/1473528 <P><EM>ArcGIS Pro 2.9.5; File Geodatabase:</EM></P><P>I have two standalone tables. I join them using Add Join, resulting in a 1:M join.</P><P>In the attribute table, I can't sort on the join table fields; the sort options are greyed out. Whereas the input fields are sortable.</P><P>Could the attribute table be enhanced so that sorting is supported on join fields when the join is 1:M?</P><P>Video:<BR /><BR /><div class="lia-vid-container video-embed-center"><div id="lia-vid-6353001723112w894h540r510" class="lia-video-brightcove-player-container"><video-js data-video-id="6353001723112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6353001723112w894h540r510'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6353001723112">(view in My Videos)</a></div><BR />For what it's worth, in 3.3.0, I don't have this problem if I specify that the join will be one-to-first in the Add Join tool. I only have this problem with one-to-many joins.&nbsp;</P> Wed, 22 May 2024 01:00:13 GMT https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-sort-on-join-field/idi-p/1473528 Bud 2024-05-22T01:00:13Z