topic Re: Adding new value to the column through script. in QlikView

Adding new value to the column through script.

Thu, 23 Jul 2015 14:17:11 GMT

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

Thanks in advance.

Re: Adding new value to the column through script.

alexandros17 — Thu, 23 Jul 2015 14:19:45 GMT

Load [Gender type ] resident tab1;

concatenate

Load 'NA' as [Gender type ];

Re: Adding new value to the column through script.

Qrishna — Thu, 23 Jul 2015 14:28:32 GMT

Another version:

tab:

load * inline [

gender

male

female

];

concatenate

load * inline [

gender

] ;

Re: Adding new value to the column through script.

Gabriel — Thu, 23 Jul 2015 21:38:40 GMT

Hi,

This will work

GENDER:

LOAD * INLINE [

Gender

Male

Female

];

Concatenate(GENDER)

LOAD * Inline [

Gender

'NA'

];

Re: Adding new value to the column through script.

antoniotiman — Thu, 23 Jul 2015 22:05:19 GMT

Hi,

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

Regards