topic how to find string with the same value on the same column? in QlikView

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

Tue, 27 Oct 2015 13:12:39 GMT

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 — Tue, 27 Oct 2015 14:25:29 GMT

May be something like this:

Table:

LOAD Field,

Capitalize(Field) as Dup;

LOAD * Inline [

Field

Rahul

RaHul

rahul

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;