Skip to main content

Access delivery date as a field

An entity may have data loaded from various partitions with different timestamps (delivery dates). Users are able to access that delivery date for each record as a field that can be transformed (sorted, routed, selected, etc.)

To add a load date field to an entity, select Include Load Date checkbox upon adding it as a source entity. The field name can be defined by users.

Include Load Date checkbox in Add Source wizard

The source entity on the canvas will now display with a delivery date field (though the data does not populate until the dataflow executes).

Delivery date field displays on the source and target entity

After connecting a target entity and mapping fields, saving, validating, executing, delivery_date is an instantiated field in the target entity.

Load date field displays the timestamp upon execution of the dataflow