Skip to main content
  • EN

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.

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


Community Stats

30,099
Posts
114,259
Replies
37,731
Members
Terms & ConditionsCookie 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.