AnsweredAssumed Answered

How do I create a single point from a csv file that has multiple records for the same point?

Question asked by sls1y1ss on Sep 13, 2019

Software ArcGIS Pro 2.4

 

I have a csv file that has multiple records (2 to 6 lines) for a single point.  How can I combine all of them to a single point and maintain all of the record information?

 

Existing Table

Address_IDProductAttribute
1001Phonea
1001Internetb
1001Cable TVc
1001

 

Desired outcome

Address_IDProduct_1Product_2Product_3Attribute_1Attribute_2Attribute_3
1001PhoneInternetCable TVabc


The csv file does have the latitude and longitude so Display XY Data can be used.
I have included a demo csv file.






Attachments

Outcomes