Populate field with text from another field based on value

Question

I had two layers (datasets). I have run the tabulate intersection to get a table of intersected features.

This is the table

Now I want to populate field with values based on "BROJ_UP" field, like this, and do that for every field. For example, value from "BROJ_UP" is 1.5, and values from NAM1 are S, Z, Z1, etc. I want to populate field NAM with text from NAM1 field, but based on value from "BROJ_UP" field.

Even better, it could be great to delete duplicate fields, so I after calculations I want to have just one field. And for every different value in "BROJ_UP" field.

Answer 1

Dean,

The code below should work for you... you'll change the values in the first 4 lines as needed... (Note though that this script assumes that all the fields specified are text fields, and does not do error checking for things like making sure the "toField" is big enough to hold the concatenated value...)

import arcpy

# Change these values as needed
layerOfIntersectedFeatures = "E:/Temporary Files/My_Layer.shp"
evalField = "BROJ_UP"
fromField = "NAM1"
toField = "NAM"
separator = ", "

print("Make a FeatureLayer for the Intersected Features")
arcpy.MakeFeatureLayer_management(layerOfIntersectedFeatures, "lyr_IntersectedFeatures")

print("Create a list and store all the unique values from the {0} field".format(evalField))
listOfEvaluatedValues= []
rows = arcpy.SearchCursor("lyr_IntersectedFeatures")
for row in rows:
    if row.getValue(evalField) not in listOfEvaluatedValues:
        listOfEvaluatedValues.append(row.getValue(evalField))

print("Loop through each value, and choose records that match that value")
for myValue in listOfEvaluatedValues:
    arcpy.MakeFeatureLayer_management("lyr_IntersectedFeatures", "lyr_" + myValue, "\"{0}\" = '{1}'".format(evalField, myValue))
    listOfRowValues = []
    rows = arcpy.SearchCursor("lyr_" + myValue)
    for row in rows:
        listOfRowValues.append(row.getValue(fromField))   # use this to get all values, even duplicate ones
        #if row.getValue(fromField) not in listOfRowValues: listOfRowValues.append(row.getValue(fromField))   # use this instead if you only want unique values

    print("Build the concatenated string and put it in the {0} field".format(toField))
    concateRowValues = separator.join(listOfRowValues)
    arcpy.CalculateField_management("lyr_" + myValue, toField, "'{0}'".format(concateRowValues), "PYTHON_9.3", "")


print("Delete Identical Rows")
arcpy.DeleteIdentical_management("lyr_IntersectedFeatures", evalField, "", "0")

Answer 2

After a thorough search as @PolyGeo pointed out, I managed to find some good solutions, and workarounds. I definitely wanted to do my own script, but I am short on schedule. For now, these solutions will provide results. Maybe these links will be useful for someone else.

This is simple code on how to Concatenate values, worked good for one variables.

These are some solutions and workarounds for my problem. Includes some data manipulations and conversions, and out-of-the-box solutions. That worked good.

And third one, and the best, this article which included the tool worked perfectly. The tool basically does what I wanted, to Concatenate Row Values, based on another row.