Changing Script so F becomes Female, M - Male

[Anonymous]

In my ListBox, I want the letter F to show up as Female, M as Male otherwise Unknown.

How do I edit the script to do that. I have an idea, but I'm not sure about everything I need to include.

This is what i'm thinking I need to include. I know I don't have the M, Male included or the unknown.

@30 as Gender (F, Female)

What do I need to add or change about this?

[kaushiknsolanki]

Hi,

     Try as follows.

     Load if(Gender = 'M','Male', If(Gender = 'F', 'Female','Unkown')) as Gender_Name

     From xyz.

     For your case Gender should be replaced by @30

Regards,

Kaushik Solanki

[Anonymous]

so in the script you sent I should replace Gender with @30?

Such as

Load if(@30 = 'M','Male', If(@30 = 'F', 'Female','Unkown')) as Gender_Name

     From xyz.

[kaushiknsolanki]

Hi,

     Yes you are right.

Regards,

Kaushik Solanki

[Anonymous]

Doesn't seem to be working for me. The Letters F and M haven't changed to Female and Male

[eliran]

Hi,

Maybe add an example since Kaushik's method is a correct one.

Eliran.

[Anonymous]

what do you mean by add an example?

[kamalqlik]

Can you upload your application here ,so we can make changes here.

regards

Kamal

[eliran]

You can attach a file (qvw) like I'm doing right now.

See the script I have attached.

Hope it helps,

Eliran.

[#10]

You need to use the new field name rather than the @30 field name.  So if you're looking at a list box make sure it's for Gender_Name rather than @30