Forum Discussion

MrTD's avatar
MrTD
Frequent Visitor
8 years ago

Relationships issues

Setup: I have a unique identifier in my 'Person' table labelled ID. These identifiers exist in two other tables 'Person Attributes' and 'Person Events' but are not unique.  I have a relationship set from Person to these tables for the ID (one to many).

When I try to create a single visual using the ID and any fields from these two tables then the visual messes up with an error.

Any advice how I would create this visual/ fix this would be helpful. Much thanks.

Need Help

9 Replies

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    8 years ago

    Hi MrTD,

     

    It would be easy to help you if you share some sample data.

    • MrTD's avatar
      MrTD
      Frequent Visitor
      8 years ago

      Sure thing!
      ID

      a
      b
      c
      d
      e
      f

      ID|Attributes

      ayoung
      atall
      bold
      bfat
      bgrey
      cwhite
      cears
      dhole
      epie
      frapture

      ID|Travelled

      aamsterdam
      abrussels
      aparis
      bswitzerland
      caustria
      ccroatia
      cgreece

      Relationship should automatically be connected by ID edit: SivaMani

  • vcastello's avatar
    vcastello
    Resolver III
    8 years ago

    Hi MrTDI think your problem is due to the bi-directional relationship.

     

    If you look closer at your photo you'll see that there are two arrows in each line of the relationship. This indicates that the relationship is bi-directional.

    Change it to 'One Way'. 

    You can do it through ....

    1.- Open the relationship tab.
    2.- Select one relationship.
    3.-Click on edit.
    4.- On the bottom-right of the page you'll see something like (I'm translating from spanish) ... Direction of the cross filter. Click there.
    5.- Choose One Way.
    6.- Click on accept.
    7.- Repeat for the other one.

    That should work

    Hope That Helps

    Vicente