Last Modified Date: 13 Dec 2017
- Tableau Desktop 10.3.2
- Amazon Redshift
- Create a calculated field to wrap [Analytics Id] in a TRIM() function
- Use the calculated field instead of the original dimension when building views
- Remove any duplicated values from the primary key field
- Use an actual unique field as the primary key or no primary key at all
CauseThis issue may be caused by a field in the database table that is designated as a primary key, but that same field has non-unique values in it.
The non-unique values make a GROUP BY clause necessary when the table is queried, but the primary key designation causes that GROUP BY clause to be automatically removed.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials