topic Re: SQL querie : Creating a table based on common fields in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1089022#M44446 <P>Ok thank you. And what if I have more than one value field ?</P> Fri, 13 Aug 2021 18:53:53 GMT Marie-JoëlleDesgagné 2021-08-13T18:53:53Z SQL querie : Creating a table based on common fields https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1088915#M44432 <P>Hello everyone !</P><P>I don't really know how to explain what I want to do so here is a example of it:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarieJolleDesgagn_0-1628868973198.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/20836iBC47B848394DA84A/image-size/medium?v=v2&amp;px=400" role="button" title="MarieJolleDesgagn_0-1628868973198.png" alt="MarieJolleDesgagn_0-1628868973198.png" /></span></P><P>Anyone knows how to do that ? Thanks a lot !!</P> Fri, 13 Aug 2021 15:36:39 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1088915#M44432 Marie-JoëlleDesgagné 2021-08-13T15:36:39Z Re: SQL querie : Creating a table based on common fields https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1088923#M44434 <P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/pivot-table.htm" target="_blank">https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/pivot-table.htm</A></P> Fri, 13 Aug 2021 15:55:02 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1088923#M44434 DavidPike 2021-08-13T15:55:02Z Re: SQL querie : Creating a table based on common fields https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1089022#M44446 <P>Ok thank you. And what if I have more than one value field ?</P> Fri, 13 Aug 2021 18:53:53 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1089022#M44446 Marie-JoëlleDesgagné 2021-08-13T18:53:53Z Re: SQL querie : Creating a table based on common fields https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1089042#M44449 <P>can you give an example?</P> Fri, 13 Aug 2021 20:03:29 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-querie-creating-a-table-based-on-common-fields/m-p/1089042#M44449 DavidPike 2021-08-13T20:03:29Z