Hi, all.
This is a shot in the dark. I have a lot of instances in which I create a pivot table from an attribute table, but then I need to integrate the calculations from the pivot table back into the original table, or, in the alternative, pull some of the attributes from the original table into the pivot to create a new attribute table. Does anyone have a resource for me as far as where to find some instruction on this? There are thousands of resources to learn excel techniques but it takes a long time to wade through them and so far I haven't found anything that addresses this particular problem. Maybe this is something I need to do in a different software package altogether.
So for example: I downloaded a table of many thousands of facilities across the US that emit pollutants. I need to be able to map each facility with graduated symbols to visualize the total amount of pollution from each facility. But, each facility can have multiple emission points, so there can be 1 or many rows per facility. It's totally inconsistent. So I use the pivot to calculate the total amount of pollution. But how do I integrate that total back into the attribute table - but just for one row for each facility. Or, how do I automate pulling the basic info about the facility (like name, lat long, a few other key items) into the pivot so I can create a new point data set? I have done it manually for some sets but for large sets this just isn't feasible.
For the most part, I just do a join of the original full point data set attribute table, and the pivot table, which just includes on identifying attribute and then the total amount of pollution. This does work but it prevents me from being able to complete certain visualizations and analysis that would be helpful. It still adds that total pollution number to each row for each facility, and I only want it to add to one row per facility - or, in the alternative, to pull the attributes I need into the pivot in a format that's like a regular table, without all of the summations, data trees, etc. I have done the join by unchecking "keep all input records" but it still retains all rows.
Sorry if this is a dumb question but I'm self taught at all of this and it's just one part of my job. Thanks for any direction you can provide!
