Question

When X found in table A and B, insert Y from B into A

  • 12 March 2017
  • 1 reply
  • 0 views
B

I have two shapefiles, A and B:

A includes the object id (Field TLNUMERO) and data fields for a long list of TLNUMERO objects. Each TLNUMERO can be listed on many rows, as data about different angles around the object is found on different rows.

B includes among others the same objects (their id also specified by field TLNUMERO) but otherwise other data / fields. Each TLNUMERO is listed only on one row.

 

 

I want FME to insert the data from two fields (say xxx and yyy) from the row with a specific TLNUMERO in table B into the rows with the same TLNUMERO in table A.

1 reply

takashi
Rank
Userlevel 2
Badge +17

Hi @benjamin, the FeatureMerger transformer might help you. Send A features to the Requestor port, send B features to the Supplier port, and set the object id attribute (TLNUMERO) to the Join On parameter for both Requestor and Supplier. Your desired features will be output via the Merged port.

The DatabaseJoiner (called Joiner in FME 2016 and earlier) could also be available depending on the format of the B features source dataset.

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
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.