Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Sreehari
Partner - Contributor III
Partner - Contributor III

Sending column values as lowercase or uppercase

Hi team,

I want to know if Qlik replicate application supports any transformation where in I can send a value of a column 
into target as lower case or upper case. 

for example:

Actual value : Cat#124

After conversion :cat#124 

Labels (3)
1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @Sreehari ,

Thanks for reaching out to Qlik Community!

There are few options which you can transfer string to lower cases. One option is in column level, you may use the function lower(), the sample :

john_wang_1-1734334043386.png

 

john_wang_0-1734333995782.png

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

3 Replies
john_wang
Support
Support

Hello @Sreehari ,

Thanks for reaching out to Qlik Community!

There are few options which you can transfer string to lower cases. One option is in column level, you may use the function lower(), the sample :

john_wang_1-1734334043386.png

 

john_wang_0-1734333995782.png

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Sreehari
Partner - Contributor III
Partner - Contributor III
Author

Thanks @john_wang 

john_wang
Support
Support

Thank you for your great support @Sreehari !

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!