topic Re: Rename a data in column via load editor - Qlik Sense in App Development

Rename a data in column via load editor - Qlik Sense

BeauP — Mon, 16 Aug 2021 10:34:02 GMT

Hi guys,

Not sure if you can use Case function on Qlik sense but anyone know how I can translate this to QlikSense:

select

case

when Model like 'abc123' then Apple

when Model like 'def456' then Android

Else Other

End as SmartPhones

from Phones

Thanks!

Taoufiq_Zarra — Mon, 16 Aug 2021 10:38:09 GMT

@BeauP maye be like

load *, if(Model='abc123','Apple',if(Model='def456','Android','Other')) as SmartPhones ; sql select * from Phones..

Kushal_Chawda — Mon, 16 Aug 2021 11:06:32 GMT

@BeauP you can use case but best way to do it is using pick and wildmatch

=pick(wildmatch(Model,'*abcd*' ,'*pqrs*'),'Apple','Android') as SmartPhones

BeauP — Wed, 18 Aug 2021 09:06:51 GMT

Thanks for this one - this has worked for me!