Joining Table - Unique value should be displayed (Irrespective of case sesitive)

[bharani8]

HI Experts - I have 2 tables.. One of the "Name" in 1st table is CAP's and in another table it is in "Small Letters".. So when i try to build an list box .. it shows both the values(i.e., CAPS and Small Letter).. Kindly find the below screen shot... I need to see only one value.. Plz Help..

Attached qvw FYR..

[arvind_patil · Accepted solution]

Hi Bharani,

Please Use Capitalize Function:

=Capitalize(Name)

You will get the output as required.

Thanks,

Arvind Patil

[bharani8]

TY! Just now i got that! U r Right!!

[md_qlikview]

Hi,

You Can write if conditions in the script level.

Eg. If( Wildmatch(Name, 'ARUN','Arun'), 'Arun', Name) as NewName

Thanks    

[arvind_patil]

Thanks,

Arvind Patil

[shiveshsingh]

Use upper() and lower() functions in your script. so that you can convert your text data either in upper case or lower case format.

Eg:

Upper(Field_Name) as Field_Name