how to display full names

[vinod2086]

Hi Friends,

i have a table in that two columns like current_user and Full name but current user is displaying short names instead of full name.

my question is for all current user field i want to map full name please help how to add.

for ex:

CURRENT_USER	FULL_NAME
Rosh.Gupta	Rosh Gupta
Ks	KSHIRSAGAR
SEaso
VMalani	Vijay Malani
balu.ingale	Balu Ingale
VSutar	VISHAL SUTAR
SEaso	Shibu Chacko Easo

for all current_user i want to display full name.

[Anonymous]

Well Vinod, try to understand, this Fullname is coming blank from database, you or QV have not done it.

Ask your customer/client to update this Full name field, you would be getting automatically if you have merged these two table with right logic.

[vinod2086]

Thanks for your reply balraj,

yes i do understand if we use apply map also we can do but multiple cases we can't map.

but still hope is there any other possible way ?

[sasikanth]

HI,

May be like this

=If(isnull(FULL_NAME),CURRENT_USER,FULL_NAME)

[Anonymous]

Well as I said earlier if it was for 1 or 2 then we cud customized at script level but not for so many.

if you gets any solution, let me know.

[Anonymous]

Try something like this,

Temp:

Mapping LOAD * Inline

[

CURRENT_USER,FULL_NAME

Rosh.Gupta,	Rosh Gupta
Ks,	KSHIRSAGAR
SEaso,
VMalani,	Vijay Malani
balu.ingale,	Balu Ingale
VSutar,	VISHAL SUTAR
SEaso,	Shibu Chacko Easo

];

MAP [CURRENT_USER] using Temp;

Test1:

LOAD * Inline

[

CURRENT_USER

Rosh.Gupta

Ks

SEaso

VMalani

balu.ingale

VSutar

SEaso

];

[Anonymous]

but for how many names he is going to do?

[Anonymous]

we can try map using function if names count is less

[Gysbert_Wassenaar]

I'm afraid I don't see the attachement.