2 Replies Latest reply: Nov 4, 2012 11:43 PM by darkyabc RSS

    How to copy field of one table to other table??

      Hi all,

       

      I just want to know if its possible or not...!!

      See there is a field called QUANTITY in Sales Table and

      There is another field called Orderprice in Dealers Table

       

      Now If I want the QUANTITY Field to Dealers Table what i have to do?? Like i want all the details to be used which are in QUANTITY field..!! I want access between Quantity and Orderprice...

       

       

      Help me out..

       

      Thank you ...!!

       

      Keep smiling

        • Re: How to copy field of one table to other table??
          Stefan Wühl

          I assume that your tables are somehow linked to each other, e.g. by a common field ProductID (anyway, it would be helpful if you could describe your data model a little closer, to avoid our wild guessing).

           

          There are lots of different solutions to your problem, like

           

          a) JOIN the tables by common field

           

          b) use a MAPPING LOAD and APPLYMAP() function

           

          c) use LOOKUP() function in your load to lookup values from a different table

           

          d) just do nothing (besides having the tables linked by ProductID) and do the calculation in the frontend

           

          To select the right solution will depend on what you exactely want to do, so some small sample app attached to this thread or some sample lines of input data togehter what you expect as outcome would help us to help your.

           

          Regards,

          Stefan