how to find string with the same value on the same column?

[#1]

Hi All,

I have a column that contains strings, sometimes some values contains the same word , but with different capital letters .

I want to undentify the values that are repeating themselves , even if they are written in a different capitals, but the value is the same.

I have knowledge of SQL, so it is hard for me to understand how to do it on QV.

how should I do that ?

thanks,

Moni

[sunny_talwar]

May be something like this:

Table:

LOAD Field,

  Capitalize(Field) as Dup;

LOAD * Inline [

Field

Rahul

RaHul

rahul

Ganesh

Ganesh

];

Join (Table)

LOAD Count(DISTINCT Field) as Count,

  Dup

Resident Table

Group By Dup;

Join (Table)

LOAD Dup,

  1 as DuplicateFlag

Resident Table

Where Count > 1;