How to manage case sensitive data.

[#1]

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?

[swuehl]

Maybe use

LOAD

     Capitalize(FIELDNAME) as FIELDNAME,

in your load script.

edit:

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.

[swuehl]

Or  have a look at

Data Cleansing

[#4]

Thanks a lot, It works

[#5]

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:

Load

     Name,

     Autonumber(lower(Name)) as NameCounter

..

Use Count(distinct NameCounter) in your expression.

[swuehl]

You are welcome!

If your request is resolved then please close this thread:

Qlik Community Tip: Marking Replies as Correct or Helpful