Solved: rename many batch of Code by first Alphabet - Qlik Community

nima94 · ‎2020-09-17

hi every one

i have filed which contains of many codes and codes are stating with an alphabet

and each alphabet represents category

for example if my code is : A1234 it means it bongs to "APPLE" category

so now as bellow i want to rename all of the cods as bellow:

can some one please help me to reach to the "NEW_CODE" ?:

tresesco · ‎2020-09-17

May be like:

Pick(Match( Left(OLD_CODE, 1), 'A', 'B', 'C', 'D', 'E'), 'Apple', 'Big', 'Cat', 'Dog', 'Egg') as NEW_CODE

And if you have many such codes, you may try with Applymap() / MapSubString()

tresesco · ‎2020-09-17

May be like:

Pick(Match( Left(OLD_CODE, 1), 'A', 'B', 'C', 'D', 'E'), 'Apple', 'Big', 'Cat', 'Dog', 'Egg') as NEW_CODE

And if you have many such codes, you may try with Applymap() / MapSubString()

nima94 · ‎2020-09-17

Thanks it works