kaiapel

Disolving n:m relate table

Discussion created by kaiapel on Mar 24, 2012
Hi User,

I'm looking for an easier solution to disolve polygons to customer number as is do. I have a postcode table with a number of customers as in the example:

ID        Postcode       Customer
1         4445             100001
2         4446             100001
3         4447             100001
4         4447             200001
5         4448             200001
6         5553             200001
7         5554             200001

and I have a postcode layer. So I have built a new table, like so:
ID       Postcode        C1          C2
1        4445              100001
2        4446              100001
3        4447              100001    200001
4        4448              200001
5        5553              200001
6        5554              200001


now I can join the postcode layer 1:1. After that I used regroup field to build the first table with the polygons (every customer has now a polygon for every postcode).
Then I deleted the fields I didn't need (with no attribut for column C2 and using disolve  by Customer to create a new shape.
The result was the polygon I need, but is there an easier way in ArcMap for doing that - like using model builder?

thx for a hint

Kai

Outcomes