Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
May be like this:
New:
LOAD DeliveryNumber,
Reason Code
From xls;
Outbound:
LOAD DeliveryNumber,
Reason Code
From QVD
Where Not Exists(DeliveryNumber);
Concatenate(Outbound)
LOAD *
Resident New;
DROP Table New;