Is it possible to use Field Calculator in ArcGIS to add text to a new field based on an if in statement?
Example: In an attribute table I have a some fields called !X!, !Y!, !Z! where "A (xx%)", "B (xx%)", "C (xx%)", "D (xx%)" are the data.
The data can be found in any field but does not have to.
I would like to use python in some form so that once I have created a New Field, I can calculate
if A in !X! copy A in !X! to New Field then continue this through !Y! and !Z!.
I believe outside of Field Calculator this will involve If in statements followed by arcpy.da.insertcursor() but I'm pretty stumped at the moment.
I hope this is clear...thanks for any help and comments!