Rename a data in column via load editor - Qlik Sense

[BeauP]

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]

@BeauP  maye  be like

load *,
if(Model='abc123','Apple',if(Model='def456','Android','Other')) as SmartPhones
;

sql select * from Phones..

[Kushal_Chawda · Accepted solution]

@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]

Thanks for this one - this has worked for me!