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

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

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

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..

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

arvind_patil — Mon, 24 Jul 2017 05:56:51 GMT

Hi Bharani,

Please Use Capitalize Function:

=Capitalize(Name)

You will get the output as required.

Thanks,

Arvind Patil

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

bharani8 — Mon, 24 Jul 2017 05:58:51 GMT

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

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

md_qlikview — Mon, 24 Jul 2017 05:59:42 GMT

Hi,

You Can write if conditions in the script level.

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

Thanks

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

arvind_patil — Mon, 24 Jul 2017 06:00:32 GMT

Thanks,

Arvind Patil

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

shiveshsingh — Mon, 24 Jul 2017 06:02:16 GMT

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