I have an Excel sheet enter it to ModelBuilder as a parameter and at next steps i need to create an expression for the fields inside the table and add the results to another field.
The problem is the fields not exist to select for expression at field calculator.
So is there any way to solve this problem and how could i write ^ inside expression. I have ArcGIS 10.5
I tried to create a python code but it give me an error Invalid field.. I wish to know what is the problem inside the code
Table name: #it will be parameter
Fields at table need to enter at expression: Geco, Par, kela (All numbers i consider all as float) The new field is MM
The code i tried with is:
Geco = arcpy.GetParameterAsFloat() Par = arcpy.GetParameterAsFloat() kela = arcpy.GetParameterAsFloat() Geco_new = '!'+Geco+'!' Par_new = '!'+Par+'!' kela_new = '!'+kela+'!' arcpy.CalculateField_management(outputfc, percentfield, '('+Geco_new+'*(2/'+Par_new+')^'+kela_new+'))', "PYTHON")