Delete missing keys

Function and purpose of the operation

The Delete Missing Keys operation deletes rows in a dataset that do not have the same values as the source dataset on the columns indicated on the Matching Fields page.

To use this operation, the user must indicate at least one field relationship, or a condition column on which to run the check.

Note: If both source and target have a null value for a column used as a condition, the system treats them as two different rows. Therefore, the condition is not satisfied.

Advanced Tab

The source scenario /period fields allow you to define a scenario/period from which to read data for the given source dataset. It is possible to specify a value using the AW parameters or through the same syntax used in the definition of cell fields.

When the field is left blank, the DTP launch scenario/period is taken into account; however, in the case of a non-existent or inactive scenario/period, the DTP will go ahead without running the operation, reporting the failed execution in the audit.

Note: the advanced tab is only visible for physical or virtual datasets.

Example

Target Dataset

Category	Product	Price
Electronics	Laptop	1329
Electronics	Bluetooth Speaker	99
Electronics	Smartphone	800
Toys	Puzzle Game	15
Home	Air Purifier	199
Books	Fantasy	20
Books	Novel	18

Matching Fields Table

Target field	Source
Category	Category
Product	Product

Source Dataset

Category	Product	Price
Electronics	Laptop	1129
Electronics	Bluetooth Speaker	120
Toys	Puzzle Game	20
Toys	Remote Control Car	50
Books	Novel	18

After data processing, the target dataset becomes:

Category	Product	Price
Electronics	Laptop	1329
Electronics	Bluetooth Speaker	99
Toys	Puzzle Game	15
Books	Novel	18