How would I add multiple excel tables' data to a excel table made in arcpy?

562
1
03-26-2021 08:24 AM
KeoniJames-Ashkewe
New Contributor

I'm trying to make a new excel table but only take pieces from excel tables throughout my excel data, how would I go about this? 

 

print(arcpy.ListTables())

#arcpy.management.AddJoin(in_layer_or_view, in_field, join_table, join_field, {join_type})
arcpy.management.AddJoin("Centroid_Map_XYTabletopoint", "INSIDE_X", "Forest Processing Facilities", "join_field", {KEEP_ALL})
arcpy.management.AddJoin("Centroid_Map_XYTabletopoint", "INSIDE_Y", "Forest Processing Facilities", "join_field", {KEEP_ALL})

# arcpy.management.CreateTable(out_path, out_name, {template}, {config_keyword}, {out_alias})
arcpy.CreateTable_management(outpath,"Centroid_FPF")
arcpy.AddField_management("Centroid_FPF","X","Double")
arcpy.AddField_management("Centroid_FPF","Y","Double")
arcpy.AddField_management("Centroid_FPF","Start_X","Double")
arcpy.AddField_management("Centroid_FPF","Start_Y","Double")

 

 

Tags (3)
0 Kudos
1 Reply
DanPatterson
MVP Esteemed Contributor

Table To Excel (Conversion)—ArcGIS Pro | Documentation if you created a proper table from your noted workflow


... sort of retired...
0 Kudos