Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Load Name,
If(Match(Gender,'Male','Female'),Gender,'NA') As Gender
Inline [
Name,Gender
Maria,Female
Mario,Male
Andrea,
John,Male
Bibi,
];
Regards
Load [Gender type ] resident tab1;
concatenate
Load 'NA' as [Gender type ];
Another version:
tab:
load * inline [
gender
male
female
];
concatenate
load * inline [
gender
NA
] ;
Hi,
This will work
GENDER:
LOAD * INLINE [
Gender
Male
Female
];
Concatenate(GENDER)
LOAD * Inline [
Gender
'NA'
];
Hi,
Load Name,
If(Match(Gender,'Male','Female'),Gender,'NA') As Gender
Inline [
Name,Gender
Maria,Female
Mario,Male
Andrea,
John,Male
Bibi,
];
Regards