hi,
in my case, i have a QVD database of 3M rows, (shipments)
every day the status of some of these shipments change and needs to be updated into the QVD file
now incremental load a large file and update the rows, this works but takes way to long (600k rows a day while only 200k are updated)
my table contains 25 fields, the update file contains 67fields (only 6 fields need to be updated, 1 is a key (same as the QVD file)
in excel it would be index('status', match('Id','Id',0))
Database:
LOAD Id,
[Forwarder Ref],
[Forwarder Track],
[Customer Ref],
[Project Name],
Performance,
[SLA Pickup Date],
[Actual Pickup Date],
[Actual Pickup Time],
[Pickup Postal Code],
[Pickup City],
[Pickup Country],
Forwarder,
[SLA Delivery Date],
[Actual Delivery Date],
[Actual Delivery Time],
[Delivery Name],
[Delivery Postal Code],
[Delivery City],
[Delivery Country],
Status,
[Last Event Date],
[Last Event],
Rootcause,
Responsible
from ****
Update:
LOAD Shipment_ID as Id,
Actual_Delivery_Date as [Actual Delivery Date],
Performance,
Actual_Pickup_Date as [Actual Pickup Date],
Shipment_Status as Status,
Event as [Last Event],
Event_Date as [Last Event Date]
from ***
could someone please help me? 🙂
thanks.
