Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I Have last and first names in one Excel table

hi friend's this is subbu i have question  please tell me any one

i have one table,

in table has employee last and employee first names fields so i  want it will display one Employee name(first name+last name) field in qlikview application .

so please tell me any one

7 Replies
MK_QSL
MVP
MVP

add below in your script..

[first name] & ' ' & [last name] as [Employee Name]

ashfaq_haseeb
Champion III
Champion III

Hi,

Try like this

Load

EmpID,

FirstName,

LastName,

FirstName&LastName as FullName,

from Table;

regards

ASHFAQ

muniyandi
Creator III
Creator III

Hi,

Try this is in Script.

Load

[First Name],

[Last Name],

[First Name]&' '&[Last Name] as [Employee Name]

.

.

.

.

From

YourTablename;

Thanks,

Muni

Not applicable
Author

thq u sir

Not applicable
Author

tnq u sir

Not applicable
Author

tnq u sir

ashfaq_haseeb
Champion III
Champion III

Hi,

Please close the thread by selecting appropriate answers.

I have seen you are not closing threads.

There are many threads that you didn't closed earlier too.

regards

ASHFAQ