Concatenation of fields in featureServer/calculate

Question

hi,

i'd like to make a calculation field from arcgis Rest services directory (from AGOL) with a concatenation from 3 fields.

i've tried many things, but not one worked.

here is what i want to do: put field1 + field2 + field... in the field "conc_hors_CCM".

Many thank if you give me a solution.

I'm novice in SQL expression for information...

LouisDECOMBE · Answer

Yes, concatenation is a fieldname.

LouisDECOMBE · Answer

Hi,

works perfectly!!!

thank you very much. i definitly have to learn sql expression !

RandyBurton · Answer

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): [{"field" : "conc_hors_CCM", "sqlExpression" : "code_mag1 + code_mag2"}]‍‍‍ Regarding the where statement, is "concatenation" a field name?