One to One Relationship

[Anonymous]

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?

[Anonymous · Accepted solution]

@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]

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.

[Anonymous]

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]

Happy to help with your dataset...