topic How to use a variable with the function calculate () with ArcGIS API for Python in ArcGIS API for Python Questions

How to use a variable with the function calculate () with ArcGIS API for Python

explocarto — Thu, 01 Nov 2018 05:36:43 GMT

calculate(where, calc_expression, sql_format='standard')

lst_country = ["country1","country2","country3"]

for country in lst lst_country:

update_result = commune_flayer.calculate(where="nom = country", calc_expression={"field": "date_horaire", "value": provinces.attributes['date_horaire']})

Thanks

Re: How to use a variable with the function calculate () with ArcGIS API for Python

Luke_Pinner — Sun, 12 Dec 2021 10:12:57 GMT

'nom = "%s"' % country
# or
'nom = "{}"'.format(country)
‍‍‍

Look up Python string formatting. Don't forget you need quotes around string values in where clauses.

Re: How to use a variable with the function calculate () with ArcGIS API for Python

explocarto — Thu, 01 Nov 2018 23:28:55 GMT

'nom = "{}"'.format(country)

It's good I finally found. It was necessary to declare this syntax

"nom = '{}'".format(country)

Thank you