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.
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.
Can you share a screenshot of the column values?
This is totally my mistake. There is an extra space, but since I am not able to change the text directly in the transform data tab, I skipped right over it. Thank you for the patience and assistance.