Skip to main content
Question

How to link two tables through a shared attribute?

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!

    2 replies

    oscard
    Influencer
    Forum|alt.badge.img+21
    • oscardInfluencer
    • Influencer
    • August 27, 2020

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

    fmerger

    davtorgh
    Contributor
    Forum|alt.badge.img+11
    • davtorghContributor
    • Contributor
    • 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.

    Reply


    Helpful Members This Week

    Community Stats

    31,579
    Posts
    119,713
    Replies
    39,226
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

    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.