topic Re: Convert the Numbers into Names in a field. in QlikView

Convert the Numbers into Names in a field.

Kohli — Wed, 18 Jul 2018 03:25:19 GMT

I have column like these

Gender

I want output 1 with Male, 0 with Female.

Gender

Male

Female

Male

Female;

Re: Convert the Numbers into Names in a field.

tresB — Wed, 18 Jul 2018 04:37:18 GMT

Use expression in the list box like:

=If(Gender=1, 'Male', 'Female')

For script:

Load

If(Gender=1, 'Male', 'Female') as Gender

from <>

Re: Convert the Numbers into Names in a field.

JaMajka1 — Wed, 18 Jul 2018 05:58:20 GMT

Hello,

if you want to replace IDs by descriptions in load script it is good to use applymap() function. Yo can define the map in the beginning of your script and then use it whetever you want.

In this case the map will be:

[M_gender]:

mapping load * inline [

gender_ID,gender_text

0,Female

1,Male

];

And the function during the resident load will be like:

applymap('M_gender',gender) as gender_text

You can find more about applymap here Data Cleansing or on qlik help https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/MappingFunctions/ApplyMap.htm.

Hope it will help ,

Maria