topic Re: Label from a related table using Label Expression in Python Questions

Label from a related table using Label Expression

DamonOsbourne — Mon, 18 Apr 2016 15:16:31 GMT

Looking for a label expression that will label from a relate. It's a 1-to-many situation & desired result is to stack the labels from a field in the related table. For example, it would be how a city would label tenants in one building, or like labeling residents (listed in a xls) on 1 apartment building.

Re: Label from a related table using Label Expression

WesMiller — Mon, 18 Apr 2016 16:03:40 GMT

See Richard Fairhurst's Blog Creating Labels with Related Table Data

Re: Label from a related table using Label Expression

DamonOsbourne — Mon, 25 Apr 2016 21:39:26 GMT

The dataset is relatively small so I don't need a dictionary. Basically just looking for the python version of this VBScript that I found:

Function FindLabel ( [RelateFieldofLayer] )

Set gp = CreateObject("esriGeoprocessing.GPDispatch.1")

strWhereClause = chr(34) & "RelateFieldofTable" & chr(34) & " = '" & [RelateFieldofLayer] & "'"

strpTable = "PathToRelatedTable"

Set prows = gp.searchcursor(strpTable,strWhereClause)

Set prow = prows.next

Do until prow is nothing

strLabel = prow.LabelField

FindLabel = FindLabel & strLabel & vbnewline

Set prow = prows.next

Loop

End Function

Re: Label from a related table using Label Expression

WesMiller — Sat, 11 Dec 2021 08:17:13 GMT

I got the below to work but it's really slow.

def FindLabel ( [RelateFieldofTable] ):
    strWhereClause = '"' + "RelateFieldofTable" + '"' +  " = '" + [RelateFieldofTable] + "'"
    strpTable =  "PathToRelatedTable" 
    rows = arcpy.SearchCursor(strpTable,strWhereClause)
    strLabel = ''
    for row in rows:
        strLabel += '\n'+ row.FieldToLabel
    return [RelateFieldofTable] + strLabel