Forum Discussion
Group By not continuously applying
What I would be looking for next is to verify that the duplicate values are the exact same. Things like trailing spaces, differing cases etc. are all treated as unique entries. Example "group item " and "group item" would show as two separate rows when grouping.
Relationship refresh failures are often caused by blank values in the one side of the relationship. You can check your grouping step for the presence of null values. These will pull through as blanks and cause the relationship error.
I did some digging for null values and did not find anything. I did notice there is a duplicate value and although I manually refreshed the data, it is still causing an error and not grouping the data as it did with the other projects.
What I would be looking for next is to verify that the duplicate values are the exact same. Things like trailing spaces, differing cases etc. are all treated as unique entries. Example "group item " and "group item" would show as two separate rows when grouping.
I double checked and they are the same. I am getting an error message with the exact name that says it cannot run the many to one relationship because they are duplicates.
The message reads: Column 'SUMMARY' in Table 'X' contains a duplicate value. This is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
