Skip to main content
Question

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

  • March 12, 2017
  • 1 reply
  • 7 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
    Contributor
    Forum|alt.badge.img+19
    • takashiContributor
    • Contributor
    • March 13, 2017

    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


    Helpful Members This Week

    Community Stats

    30,918
    Posts
    117,142
    Replies
    38,720
    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.