Skip to main content
I am currently trying to merge two tables (one is a shape file with county polygon info and the other is a excel file with info about the county. My goal is to get the polygon info into the table with all the data. Both have essentially the same field (counties) but are named two different things. One of the files calls it counties while the other is a shape file that just calls it name and has the polygon data. What is the best way to merge these files or is it better to use ArcMap tools to do the merger?

Hi,

It can be done with feature merger transformer,

Since you want the excel file as output so connect excel to requester and shape file to supplier. In the properties, under "join on" select the counties under requester and name under supplier in the properties.

Consider both Merged and Not Merged and verify whether merging has been done for entire data or not.

Pratap


Reply