Hi Simon.
This is a script to run in Python - just use a Jupyter Notebook in Pro. Note that I matched your variable naming when available. In the first code block (chunk):
classes=['AB0', 'AB1', 'AB2', 'AB3', 'AB4']
classes_pct = ['AB0_pct', 'AB1_pct', 'AB2_pct', 'AB3_pct', 'AB4_pct']
These are values I created for the lucode (as examples). Follow Comments (#) and reach out with any Qs. Note that you need to create your new feature in advance - feat_create, and add the classes_pct values as fields to the attribute table of said new feature. Since they are percentages, create a type Double.
@DanPatterson method is way easier if you have the license, however you may need to copy in the geometry when it's run as upon my test, it only outputs a Table, not a Feature Class.
# esri forum
import numpy as np
import pandas as pd
import copy as copy
# Original Split Feature
feat_base = 'esri_forum'
# Create a New Feature of Same geometry
feat_create = 'esri_forum2'
classes=['AB0', 'AB1', 'AB2', 'AB3', 'AB4']
classes_pct = ['AB0_pct', 'AB1_pct', 'AB2_pct', 'AB3_pct', 'AB4_pct']
# Use this later for efficieny - it's a dictionary
fld_dict={k:v for k,v in zip(classes, classes_pct)}
# Create a Pandas DataFrame (basically an Excel spreadsheet)
# Number of rows = Number of unique ListDir values
# Number of cols = Number of unique classifications i.e. Grass, Trees, etc.
num_rows = 3
num_cols = 5
arr = np.zeros([num_rows, num_cols])
col_names=copy.copy(classes_pct)
unique_ListEntry=[100,111,124]
df_pct=pd.DataFrame(data=arr, index=unique_ListEntry, columns=col_names)
# Populate DataFrame with Values from Attribute Table per row and column
with arcpy.da.SearchCursor(feat_base, ['lucode','Perc','ListEntry']) as cursor_src:
for row in cursor_src:
col_name=fld_dict[row[0]]
df_pct.at[row[2], col_name]=row[1]
# Trick to create new Row ONLY when it hasn't been created; only need one row per ListEntry
arr_flag=np.full((3,1), False)
df_flag = pd.DataFrame(arr_flag, index=unique_ListEntry, columns=['FLAG'])
# Add Rows to New Feature Class; one row for each unique ListEntry
# flds_tgt = the fields to include in new FC
flds_tgt=['SHAPE@','ListEntry']
flds_tgt.extend(classes_pct)
with arcpy.da.SearchCursor(feat_base, ['SHAPE@','ListEntry']) as cursor_src:
with arcpy.da.InsertCursor(feat_create, flds_tgt) as cursor_tgt:
for row_src in cursor_src:
if not df_flag.loc[row_src[1],'FLAG']:
new_row_atts = df_pct.loc[row_src[1]].to_list()
# Add geometry
new_row = [row_src[0]]
# Add ListEntry Val
new_row.append(row_src[1])
new_row.extend(new_row_atts)
df_flag.at[row_src[1],'FLAG']=True
cursor_tgt.insertRow(new_row)
else:
pass
del cursor_src
del cursor_tgt
