Latest Contributions by JohannesLindner

Caclulate x and y coordinates in the point fc   Run the Summary Statistics tool with statistic type Count and the coordinate fields as Case fields.     ... View more

For Field Calculation: // change the first line depending on field var p = Geometry($feature).paths[0][0] // BegLocation var p = Geometry($feature).paths[-1][-1] // EndLocation var streets_at_point = Intersects($featureset, p) var this_street = $feature.NAME_ALF var other_streets = Filter(streets_at_point, "NAME_ALF<> @this_street") var street_names = [] for(var os in other_streets) { Push(street_names, os.NAME_ALF) } return Concatenate(Distinct(street_names), ", ")     For Attribute Rule: // Calculation Attribute Rule // triggers: Insert, Update, // field: empty var p_start = Geometry($feature).paths[0][0] var p_end = Geometry($feature).paths[-1][-1] var this_street = $feature.NAME_ALF var streets_start = Intersects($featureset, p_start) var other_streets = Filter(streets_start, "NAME_ALF<> @this_street") var start_names = [] for(var os in other_streets) { Push(start_names, os.NAME_ALF) } var streets_end = Intersects($featureset, p_end) var other_streets = Filter(streets_end, "NAME_ALF<> @this_street") var end_names = [] for(var os in other_streets) { Push(end_names, os.NAME_ALF) } return { result: { attributes: { BegLocation: Concatenate(Distinct(start_names), ", "), EndLocation: Concatenate(Distinct(end_names), ", ") } } } ... View more

The tool only generates a 1:1 table, the match field and file name have to be exactly the same.   With this little script, you can do what you want: # same parameters as in the tool in_table = "TestPoints" in_folder = r"N:\ags1_daten\gewaesserkataster\Projekt\Bearbeitung\test" out_match_table = r"memory\match2" key_field = "OBJECTID" input_data_filter = "*" # eg "*.jpg" relative_path = True from pathlib import Path # create match table p = Path(out_match_table) match_table = arcpy.management.CreateTable(str(p.parent), str(p.name)) arcpy.management.AddField(match_table, "Filename", "TEXT") arcpy.management.AddField(match_table, "MatchID", "LONG") # get all files that match your filter in_files = list(Path(in_folder).glob(input_data_filter)) # for each row in in_table, get all files that match the key field or start with key field followed by "_" with arcpy.da.InsertCursor(match_table, ["MatchID", "Filename"]) as i_cur: with arcpy.da.SearchCursor(in_table, [key_field]) as s_cur: for row in s_cur: key = str(row[0]) for f in in_files: if f.stem == key or f.stem.startswith(key + "_"): fn = f.name if relative_path else str(f) i_cur.insertRow([row[0], fn])   ... View more

Hmmm, interesting. I'm still on 2.8, so I can't test it. @sofoo Assuming you use Pro 2.9 or later, Does this label expression work for feature classes? Expects($feature, "*") var allFields = [] for (var j in $feature){ Push(allFields, j) } return allFields   ... View more