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