Forum Discussion
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...
Anonymous - That error indicates that the key column of the dimension (one-side) has duplicates or blanks. To troubleshoot:
- Make sure you're joining on the correct columns.
- Make sure there are no blanks in the key (join) column.
- 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 - That error indicates that the key column of the dimension (one-side) has duplicates or blanks. To troubleshoot:
- Make sure you're joining on the correct columns.
- Make sure there are no blanks in the key (join) column.
- 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.
I also appreciate Kudos.
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.
Happy to help with your dataset...
