2 Replies Latest reply: Jul 12, 2018 8:17 AM by Bala Bhaskar RSS

    concatenating the values of 2 different fields to one field in a table

    anusha hegde

      Hi all,

       

      Temp:

      Load

      ListPriceTypeID,

      '43' as NetPriceTypID

      From abc.qvd;

       

      In the ablove script, I want a single field called PriceTypeID that contains the values of both ListPriceTypeID and NetPriceTypID. How can I get it ?

       

      For example if,

      the values of ListPriceTypeID are

      1

      2

      3

      4

      output should be:

      PriceTypeID

      1

      2

      3

      4

      43

       

      Appreciate your help.

       

      Thanks in advance,

      Anusha.