Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

same value, multiple lines

Hi,

May I ask your assistance, how will I fix this concern, please?

 

Record Type
PurP
Purp
purp
ShpA
Shpa
shpa

My output should be (together with other details connected to this column) 2 rows only (PurP and Shpa) regardless if  they are recorded in different format. How will I combined each of the record types?

Thanks in advance.

Regards,

Michelle

4 Replies
darkhorse
Valued Contributor

Re: same value, multiple lines

Hi,

You can use upper() function in script. https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/Upper....

If you are so sensitive about exact letters you need to use if statements in load script.

Best Regards

Serhan

rupamjyotidas
Valued Contributor

Re: same value, multiple lines

Either do Lower() or Upper().

Thanks

mov
Esteemed Contributor III

Re: same value, multiple lines

... or Capitalize()

Not applicable

Re: same value, multiple lines

Thank you all!

What you've suggested are working. Thanks a lot for your help!