Concatenation of fields in featureServer/calculate

977
4
12-01-2016 07:13 AM
LouisDECOMBE
Occasional Contributor

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...

Tags (2)
0 Kudos
4 Replies
LouisDECOMBE
Occasional Contributor

Just to precise that is from Arcgis online feature service

0 Kudos
RandyBurton
MVP Alum

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?

0 Kudos
LouisDECOMBE
Occasional Contributor

Hi,

works perfectly!!! 

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

0 Kudos
LouisDECOMBE
Occasional Contributor

Yes, concatenation is a fieldname.

0 Kudos