Adding new value to the column through script.

[#1]

Hi,

I have a field called Gender type with values Male and Female.I want to add one more value called 'NA' to the filed Gender Type.How can I do this through sctipting,

Ex.List box.

Gender type

Male

Female.

I want this list box look like,

Gender Type

Male

Female

NA

Thanks in advance.

[alexandros17]

Load [Gender type ] resident tab1;

concatenate

Load 'NA' as [Gender type ];

[Qrishna]

Another version:

tab:

load * inline [

gender

male

female

];

concatenate

load * inline [

gender

NA

] ;

[Gabriel]

Hi,

This will work

GENDER:

LOAD * INLINE [

    Gender

    Male

    Female

];

Concatenate(GENDER)

LOAD * Inline [

Gender

'NA'

];

[antoniotiman · Accepted solution]

Hi,

Load Name,
If(Match(Gender,'Male','Female'),Gender,'NA') As Gender
Inline [
Name,Gender
Maria,Female
Mario,Male
Andrea,
John,Male
Bibi,
];

Regards