Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merging from different fields

Hi their.

i need help in merging a NAME and a SURNAME from different fields. Could i possibly get the steps to doing this?

3 Replies
v_iyyappan
Specialist
Specialist

Hi

     Using the '&' Operator to merging the fields.

NAME &''& SURNAME AS FULLNAME

Regards,

Iyyappan

Not applicable
Author

     Hi again Iyyapan v

      Name &"& Surname as Fullname did merge the two field but renaming it as FULLNAME didnt work. i left an example to help, Thanks.

     @3 as MemberNo,

     @4 as Surname,

     @5 as Initials,

     @6 as Title,

     @7 as FirstName,

     @8 as CashCustomerNo,

v_iyyappan
Specialist
Specialist

Hi

     Use like this

    

TempTable:         

    Load                         

              @3 as MemberNo,

              @4 as Surname,

              @5 as Initials,

              @6 as Title,

              @7 as FirstName,

              @8 as CashCustomerNo,

From

     DataSource

Table:

     Load

               FirstName&Surname As FullName,

               MemberNo,

               Initials,

               Title,

               FirstName,

               CashCustomerNo

Resident TempTable;

you want space from FirstName and Surname use like   FirstName &' '& Surname AS FullName

Hope its help

Regards,

Iyyappan