I'll try to explain this my best.
I have one table that I am trying to break down into a smaller one. The table has LOT numbers and OWNERS as the column headers. The LOT numbers can sometimes have multiple owners ie John and Peter own Lot 12345. Therefore in the table it was have the same LOT number twice with a unique OWNER.
ie LOT OWNER
12345 John
12345 Peter
What I want to do is to display the unique LOT number, and the OWNERS combined into the same column.
ie LOT OWNER
12345 John, Peter
I really just want to make my table smaller by changing the relationships. Any assistance would be greatly appreciated as I am not the strongest on the Python/Programming/Development side of GIS.
Hi Reginald,
1. One way you can do this is by first running a Summary Statistics on the table to summarize by the LOT field. For the Statistic, you can choose any other field and statistic value:
2. Add a TEXT field to this output table (i.e. OWNER).
3. You can then execute the following python script. You will want to update the Variables to the directory/database, original table, and the output table from the Summary Statistics tool.