topic Sending column values as lowercase or uppercase in Qlik Replicate

Sending column values as lowercase or uppercase

user2828 — Mon, 16 Dec 2024 07:18:30 GMT

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

Re: Sending column values as lowercase or uppercase

john_wang — Mon, 16 Dec 2024 07:32:08 GMT

Hello @user2828 ,

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 :

Hope this helps.

John.

Re: Sending column values as lowercase or uppercase

user2828 — Mon, 16 Dec 2024 07:46:50 GMT

Thanks @john_wang

Re: Sending column values as lowercase or uppercase

john_wang — Mon, 16 Dec 2024 07:48:01 GMT

Thank you for your great support @user2828 !