View the original community article here

Last tested: Jun 24, 2019

The Problem

My result set is returning duplicates that only differ in uppercase and lowercase. For example, 'shorts' and 'Shorts' are being treated as two different rows.

A Solution

These results are literally different records in the database. So if you want to coerce them to be the same, you'll need to edit the SQL of the field. One example is to convert the field to lowercase using the LOWER function:

dimension: item_name {

type: string

sql: LOWER(${TABLE}.item_name) ;;

}

The actual function may differ depending on your database. You may instead try to use UPPER or an equivalent if that's how you want to view the results.