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.
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.