Formating a string value

[#1]

Hi,

Can anyone help me out in this,

I have one column, which has values like

Program

Application Manager

Applications

DFS200x

Accounts

ACCOUNTS

Here the Accounts and ACCOUNTS both are same, but due to the upper and lower case, qlik view considering as different and it shows as two different Program, I need to solve this.

Other values are correct,

Thanks in Advance,

Dhoulath

[achiever_ajay]

hi,

In edit script you can solve this problem during loading as..

Load

upper(Field1) as Field1,

....

...

.

This fetch you all your to Upper case.. which will solve your problem..