https://community.esri.com/t5/arcgis-pro-questions/labeling-fields/m-p/1399792#M80830 <P>Hello,&nbsp;</P><P>I have census data where the fields in the attribute table are coded (SF for State) and there is another sheet that has a field with the codes and a field that decodes them (SF | State/County). How do I combine the two sheets to have the labeling show the decoded field name?</P> Fri, 22 Mar 2024 19:48:27 GMT ThomasHusmann 2024-03-22T19:48:27Z https://community.esri.com/t5/arcgis-pro-questions/labeling-fields/m-p/1399792#M80830 <P>Hello,&nbsp;</P><P>I have census data where the fields in the attribute table are coded (SF for State) and there is another sheet that has a field with the codes and a field that decodes them (SF | State/County). How do I combine the two sheets to have the labeling show the decoded field name?</P> Fri, 22 Mar 2024 19:48:27 GMT https://community.esri.com/t5/arcgis-pro-questions/labeling-fields/m-p/1399792#M80830 ThomasHusmann 2024-03-22T19:48:27Z https://community.esri.com/t5/arcgis-pro-questions/labeling-fields/m-p/1400278#M80893 <P>Couple of options around the <A href="https://pro.arcgis.com/en/pro-app/3.1/help/data/tables/joins-and-relates.htm" target="_self">Join</A> functionality.<BR /><BR />You could create a temporary join between the two datasets based on the abbreviated field which will connect them, and then you could pick the decoded field as the label field.<BR /><BR />Or, you could permanently append (and use to label) the decoded field using the "<A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/join-field.htm" target="_self">Join Field</A>" geoprocessing tool, again basing this on the abbreviated field.</P> Mon, 25 Mar 2024 11:35:52 GMT https://community.esri.com/t5/arcgis-pro-questions/labeling-fields/m-p/1400278#M80893 RichardHowe 2024-03-25T11:35:52Z