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