Skip to main content
Question

Merfing fields of records in Same Table

  • January 27, 2013
  • 1 reply
  • 17 views
S
Hi All,

 

 

I have two different tables(A & B) in SDE, which are having a common field to maintain relationship between the tables. I have requirement like finding the relation records in table B with respect to the records in table A. In table B it may contains one or more (max 4) records will available. After finding the relationship reords, then merge the fields of relation records to record in table A.

 

 

Can anyone please suggest of how to approach my requirement.

 

 

Thanks,

 

Seshu
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    sigtill
    Supporter
    Forum|alt.badge.img+25
    • sigtillSupporter
    • Supporter
    • January 28, 2013
    This seems like a task to complete with a JOINER (if yuo know some SQL-syntax) : 

     

     

    If you want to do it only with multiple Transformers the FeatureMerger will be your friend. More information regarding both of them can be found here:

     

     

    http://evangelism.safe.com/fmeevangelist79/

     

     

    The real SigTill

    Community Stats

    32,629
    Posts
    123,852
    Replies
    41,005
    Members
    Terms & ConditionsAccessibility statement
    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.