Skip to main content
Question

How to link two tables through a shared attribute?

  • August 26, 2020
  • 2 replies
  • 9 views
C

I have two tables: Room and Furniture. In the Room table, I have room_id, and furnitures attributes, and in the Furiture table, I have room_id and furniture_name...etc. How to link these two tables through room_id, so each room will have a list of furnitures that belong to that room?

 

Thanks for your input!

    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.

    2 replies

    oscard
    Influencer
    Forum|alt.badge.img+22
    • oscardInfluencer
    • Influencer
    • 344 replies
    • August 27, 2020

    Use the FeatureMerger. It has an option to make lists.

    fmerger

    davtorgh
    Contributor
    Forum|alt.badge.img+11
    • davtorghContributor
    • Contributor
    • 105 replies
    • August 27, 2020

    HI,

     

    do you need to add, to the features of the 'Room' table, the 'furniture_name' attribute from the 'Furniture' table? I'm asking this because you said there are already some furniture attribute in the 'Room' table.

    Maybe a FeatureJoiner followed by an Aggregator could be a solution.

    Community Stats

    32,070
    Posts
    121,785
    Replies
    39,700
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility 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.