topic Re: How can I include featureClass names with join field names using ModelBuilder ? in ArcGIS Pro Questions

How can I include featureClass names with join field names using ModelBuilder ?

khalidechlouchi — Sun, 19 Dec 2021 22:59:13 GMT

Hello!

I try to make a join of the fields using the iterator for multiple FeaturesClasses that have the same fields. So, I should differentiate them by their FeaturesClasses names. like this : NameFeaturesClasses_NamefildJoin , for example BATI_CAout_QCooling.

How can I include featureClasses names with join field names using ModelBuilder ?

thank you for your collaboration.

Re: How can I include featureClass names with join field names using ModelBuilder ?

DanPatterson — Sun, 19 Dec 2021 23:27:49 GMT

Add Join and Join field are your two conventional options.

A third alternative is to build arrays with the desired data using TableToNumPyArray.

Assemble the arrays in NumPy and use ExtendTable once with the resultant or use it multiple times to permanently join to a featureclass table.

You can change the field names in numpy

a = TableToNumPyArray(in_fc, "*", skip_nulls=True) flds = a.dtype.names new_flds = [f"Bati_{i}" for i in flds] new_flds ['Bati_OBJECTID', 'Bati_Shape', 'Bati_ids', 'Bati_CENTROID_X', 'Bati_CENTROID_Y', 'Bati_INSIDE_X', 'Bati_INSIDE_Y', 'Bati_PART_COUNT', 'Bati_PNT_COUNT', 'Bati_Sort_', 'Bati_Shape_Length', 'Bati_Shape_Area'] # --- # -- magic time from arcpy.da import ExtendTable a.dtype.names = new_flds sub_arr = a[['Bati_OBJECTID', 'Bati_PART_COUNT']] ExtendTable(in_fc, "OBJECTID", sub_arr, 'Bati_OBJECTID')

Magic done

of course you would want a preselected list of fields to produce/slice fields from the main array to make sub_arr.

Re: How can I include featureClass names with join field names using ModelBuilder ?

khalidechlouchi — Mon, 20 Dec 2021 21:27:26 GMT

Thank you for your help, I will try this approach.

Re: How can I include featureClass names with join field names using ModelBuilder ?

DanPatterson — Sun, 23 Jan 2022 05:25:44 GMT

closed?