Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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