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?
Try as follows.
Load if(Gender = 'M','Male', If(Gender = 'F', 'Female','Unkown')) as Gender_Name
For your case Gender should be replaced by @30
so in the script you sent I should replace Gender with @30?
Load if(@30 = 'M','Male', If(@30 = 'F', 'Female','Unkown')) as Gender_Name
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