I need to specify a "group by" clause for UpdateCursor arcpy.da. From here I found out that it's possible to do using an optional pair of SQL prefix and postfix. But there are no examples and I'm stuck with the syntaxis problem. Can, please, smbd help me?
PS. I've tried various modifications of
"(None, 'GROUP BY "INPUT_FID"')", but still can't get it.
Thank you in advance.
Here is the part of the code I'm using:
oDSFields = ('INPUT_FID','NEAR_FID','DISTANCE', popTotalField, popBlacksField) kernel = 0 alpha = 0.005 #, "(None, 'GROUP BY "INPUT_FID"')" with arcpy.da.UpdateCursor("outDistanceSorted", oDSFields, "(None, 'GROUP BY "INPUT_FID"')") as cursor: for row in cursor: kernel = float(math.exp(-0.5*math.pow(row/alpha, 2)))