Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

One to One Relationship

I have a table that is not allowing me to create a 1:* relationship when it should. 

I've tried to remove duplicate, null, and blank values, and I've exported to Excel to try and highlight duplicate values, but it's still not letting me set the relationship. 

 

It's automatically creating a many to many relationship when it should be 1:*

I get this error. *The cardinality you selected in't valid for this relationship

 

any ideas?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous  - That error indicates that the key column of the dimension (one-side) has duplicates or blanks. To troubleshoot:

    1. Make sure you're joining on the correct columns.
    2. Make sure there are no blanks in the key (join) column.
    3. Make sure there are no duplicates in the key (join) column.
    I hope this helps. If it does, please Mark as a solution.
    I also appreciate Kudos.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous  - That error indicates that the key column of the dimension (one-side) has duplicates or blanks. To troubleshoot:

    1. Make sure you're joining on the correct columns.
    2. Make sure there are no blanks in the key (join) column.
    3. Make sure there are no duplicates in the key (join) column.
    I hope this helps. If it does, please Mark as a solution.
    I also appreciate Kudos.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      yes, I've gone through those steps and it's still registering the column as a Many column... I have this same issue in another model that I'm working on and I'm stuck as to what to do to resolve it.

       

      • RobbeVL's avatar
        RobbeVL
        Impactful Individual
        6 years ago

        Happy to help with your dataset...

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I've fixed it... I'm not exactly sure how, but I re-did the qurey and merge.

      On my original join I set the criteria to filter the last report date and join w/ the other source data.

      On the new one, I first copied my table then filtered to include only the Latest report, then merged on that. That worked.

      Thanks.