3 Replies Latest reply: Apr 5, 2012 7:33 AM by Iyyappan V RSS

Merging from different fields

qlikviewj.r

Hi their.

 

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

  • Merging from different fields
    Iyyappan V

    Hi

     

         Using the '&' Operator to merging the fields.

     

    NAME &''& SURNAME AS FULLNAME

     

    Regards,

    Iyyappan

    • Merging from different fields
      qlikviewj.r

           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,

      • Merging from different fields
        Iyyappan V

        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