topic Concatenation of fields in featureServer/calculate in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43960#M191 <HTML><HEAD></HEAD><BODY><P>hi,&nbsp;</P><P></P><P>i'd like to make a calculation field from arcgis Rest services directory (from AGOL) with a concatenation from 3 fields.</P><P></P><P>i've tried many things, but not one worked.</P><P></P><P>here is what i want to do: put field1 + field2 + field... in the field "conc_hors_CCM".</P><P></P><P>Many thank if you give me a solution.</P><P></P><P>I'm novice in SQL expression for information...</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/274085_sql.png" style="width: 620px; height: 209px;" /></P></BODY></HTML> Thu, 01 Dec 2016 15:13:10 GMT LouisDECOMBE 2016-12-01T15:13:10Z Concatenation of fields in featureServer/calculate https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43960#M191 <HTML><HEAD></HEAD><BODY><P>hi,&nbsp;</P><P></P><P>i'd like to make a calculation field from arcgis Rest services directory (from AGOL) with a concatenation from 3 fields.</P><P></P><P>i've tried many things, but not one worked.</P><P></P><P>here is what i want to do: put field1 + field2 + field... in the field "conc_hors_CCM".</P><P></P><P>Many thank if you give me a solution.</P><P></P><P>I'm novice in SQL expression for information...</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/274085_sql.png" style="width: 620px; height: 209px;" /></P></BODY></HTML> Thu, 01 Dec 2016 15:13:10 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43960#M191 LouisDECOMBE 2016-12-01T15:13:10Z Re: Concatenation of fields in featureServer/calculate https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43961#M192 <HTML><HEAD></HEAD><BODY><P>Just to precise that is from Arcgis online feature service</P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/274087_Image1.png" style="width: 620px; height: 446px;" /></P></BODY></HTML> Thu, 01 Dec 2016 15:23:51 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43961#M192 LouisDECOMBE 2016-12-01T15:23:51Z Re: Concatenation of fields in featureServer/calculate https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43962#M193 <HTML><HEAD></HEAD><BODY><P>Assuming your where statement is correct, try this statement in the update box (note the use of double quotes around the expression and not the field names):</P><PRE class="language-none line-numbers"><CODE>[{"field" : "conc_hors_CCM", "sqlExpression" : "code_mag1 + code_mag2"}]‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>Regarding the where statement, is "concatenation"&nbsp;a field name?</P></BODY></HTML> Thu, 01 Dec 2016 18:49:17 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43962#M193 RandyBurton 2016-12-01T18:49:17Z Re: Concatenation of fields in featureServer/calculate https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43963#M194 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>works perfectly!!!&nbsp;</P><P></P><P>thank you very much. i definitly have to learn sql expression !</P></BODY></HTML> Fri, 02 Dec 2016 08:53:23 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43963#M194 LouisDECOMBE 2016-12-02T08:53:23Z Re: Concatenation of fields in featureServer/calculate https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43964#M195 <HTML><HEAD></HEAD><BODY><P>Yes,&nbsp;<SPAN style="background-color: #ffffff;">concatenation is a fieldname.</SPAN></P></BODY></HTML> Fri, 02 Dec 2016 08:55:02 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/concatenation-of-fields-in-featureserver-calculate/m-p/43964#M195 LouisDECOMBE 2016-12-02T08:55:02Z