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,
I want this list box look like,
Thanks in advance.
Load [Gender type ] resident tab1;
Load 'NA' as [Gender type ];
load * inline [
This will work
LOAD * INLINE [
LOAD * Inline [
Load Name, If(Match(Gender,'Male','Female'),Gender,'NA') As Gender Inline [ Name,Gender Maria,Female Mario,Male Andrea, John,Male Bibi, ];
Retrieving data ...