1 Reply Latest reply: Sep 14, 2016 10:15 AM by Sunny Talwar RSS

    Update

    sundarraj ramchandran

      Hi All,

       

      I have two tables where the Reason code changes daily for the Delivery number.The Delivery number remains the same.I want update only few records(changed Reason Code) to be udpated from 2nd table to first table.For other records 1st table  which are dont have records in 2nd table should ( Reason Code)remain the same(undisturbed).

       

       

      Outbound:

      Load

      DeliveryNumber,

      Reason Code

       

      From QVD;

       

      New:

      Load

      DeliveryNumber,

      Reason Code

       

      From xls;