https://community.esri.com/t5/arcgis-pro-ideas/make-aggregation-query-layer-use-text-column-as/idi-p/1437900 <P><EM>ArcGIS Pro 3.3.0; Oracle 18c Database:</EM></P><P>I want to use a FC as the Target Feature Class in the Make Aggregation Query Layer tool. The FC has a text field that is a unique identifier.</P><P>The tool is giving me an error:</P><BLOCKQUOTE><P>Error 000358 No fields can be mapped to unique identifier.</P></BLOCKQUOTE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_3-1715409261801.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/103843i6BC0C5D8014B0305/image-size/large?v=v2&amp;px=999" role="button" title="Bud_3-1715409261801.png" alt="Bud_3-1715409261801.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_2-1715408655311.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/103842iFEDBECE59B169E8A/image-size/medium?v=v2&amp;px=400" role="button" title="Bud_2-1715408655311.png" alt="Bud_2-1715408655311.png" /></span></P><P>If I add a Long Integer field to the FC, then that field can be used as the unique ID. I wouldn't get the error.&nbsp;</P><P>But that's not how my data is structured. My ID field is text, not integers. Could the tool be enhanced so that a text field can be used as the unique ID?</P><P>&nbsp;</P> Thu, 13 Jun 2024 15:52:45 GMT Bud 2024-06-13T15:52:45Z https://community.esri.com/t5/arcgis-pro-ideas/make-aggregation-query-layer-use-text-column-as/idi-p/1437900 <P><EM>ArcGIS Pro 3.3.0; Oracle 18c Database:</EM></P><P>I want to use a FC as the Target Feature Class in the Make Aggregation Query Layer tool. The FC has a text field that is a unique identifier.</P><P>The tool is giving me an error:</P><BLOCKQUOTE><P>Error 000358 No fields can be mapped to unique identifier.</P></BLOCKQUOTE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_3-1715409261801.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/103843i6BC0C5D8014B0305/image-size/large?v=v2&amp;px=999" role="button" title="Bud_3-1715409261801.png" alt="Bud_3-1715409261801.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_2-1715408655311.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/103842iFEDBECE59B169E8A/image-size/medium?v=v2&amp;px=400" role="button" title="Bud_2-1715408655311.png" alt="Bud_2-1715408655311.png" /></span></P><P>If I add a Long Integer field to the FC, then that field can be used as the unique ID. I wouldn't get the error.&nbsp;</P><P>But that's not how my data is structured. My ID field is text, not integers. Could the tool be enhanced so that a text field can be used as the unique ID?</P><P>&nbsp;</P> Thu, 13 Jun 2024 15:52:45 GMT https://community.esri.com/t5/arcgis-pro-ideas/make-aggregation-query-layer-use-text-column-as/idi-p/1437900 Bud 2024-06-13T15:52:45Z