XY to Line attribute table is all

Question

I've got two point features that I am comparing. Both represent physical structures. The following was my workflow: 1) reprojected features to WGS 84 (4326) 2) I added fields for X and Y values and calculated geometry appropriately 3) joined the first table to the the second 4) Ran XY To Line, and included and ID that was the structure building number Line Type: Geodesic ID: buildingID SpatialRef: GCS_WGS_1984 Results: XY to Line created the lines, but ALL attributes are and the ID field didn't appear. There were NO errors. Questions: Why are the attributes ? Where's my ID field?

LoriEmersonKDOT · Answer

When running the XY to Line arcpy in a Python Notebook in ArcGIS Pro version 3.5.4, the X,Y attributes are NULL with a join table when the "Preserve Attributes" option is unchecked.  (IMHO, this is a bug).

If I check the "Preserved Attributes" option, all the attributes are non-NULL including my X,Y attributes.

Or, if I remove the join and run the XY to Line tool with "Preserve Attributes" option unchecked, the X, Y attributes are non-NULL.

DanPatterson_Retired · Answer

Glad it worked out...

I have just gotten into the habit of making joins permanent every time... you can always delete what you don't want after you are done.

GabrielMarcus · Answer

That worked. It's too bad that step doesn't appear in the documentation.