Update

Anonymous — Wed, 14 Sep 2016 14:10:52 GMT

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;

Re: Update

sunny_talwar — Wed, 14 Sep 2016 14:15:08 GMT

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;

topic Re: Update in QlikView

Update

Re: Update