How to manage data if they are case sensitive.
Eg: My excel file has Ranjit and ranjit. Now the count of this two are different? How can I make them count as same?
Capitalize(FIELDNAME) as FIELDNAME,
in your load script.
If you want to convert all values to lower case, use Lower(FIELDNAME) instead.
Basically, use string functions to transform your data values to a consistent case use.
Follow Stefan approach to convert the data into capitalize or lower or Upper. But do you need to show values as it is in the source but need to count only once then add new field counter like below:
Autonumber(lower(Name)) as NameCounter
Use Count(distinct NameCounter) in your expression.