topic Merging from different fields in Water Cooler

Merging from different fields

Thu, 05 Apr 2012 10:03:32 GMT

Hi their.

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

v_iyyappan — Thu, 05 Apr 2012 10:29:39 GMT

Using the '&' Operator to merging the fields.

NAME &''& SURNAME AS FULLNAME

Regards,

Iyyappan

Thu, 05 Apr 2012 11:12:35 GMT

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 — Thu, 05 Apr 2012 11:33:25 GMT

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