Skip to main content
Solved

How to join multiple shp files with common field?

  • November 2, 2017
  • 1 reply
  • 6 views
J
Forum|alt.badge.img

Hello,

I have 3 shp files which I need to join

File 1

Postal code and name

File 2

Admin code and name

File 3

Admin code and state

Name in File 1 and File 2 has identical list

Admin code in File 3 is first two digits of Admin code in File 2

I need to create single file which would have the Postal Code, Name and State.

I tried to create Reader for File 1 and a Reader for File 2 and write them into the same file. The transaction was successful, however it first listed all items from File 1 and below all items from File 2.

Best answer by jdh

You need to use a FeatureMerger to join two streams of data together.

Use a substringextractor on the admin code in file 2, so that you have the same value as File 3.

One FeatureMerger with File 1 as requestor and File 2 as supplier, on name.

The merged output of that goes into a second featureMerger with File 3 as the supplier on Admin Code (truncated)

View original
Did this help you find an answer to your question?

1 reply

jdh
Contributor
Forum|alt.badge.img+28
  • jdhContributor
  • Contributor
  • Best Answer
  • November 2, 2017

You need to use a FeatureMerger to join two streams of data together.

Use a substringextractor on the admin code in file 2, so that you have the same value as File 3.

One FeatureMerger with File 1 as requestor and File 2 as supplier, on name.

The merged output of that goes into a second featureMerger with File 3 as the supplier on Admin Code (truncated)

Reply


Helpful Members This Week

Community Stats

31,101
Posts
117,914
Replies
38,855
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.