Data Row Functions


Function

Description

Example

GetCurrentRow

Provides low-level access to the current input row. The result can be used as an argument for functions which require access to the entire row.

GetCurrentRow()

GetParentId

Determines the unique identifier of a row’s parent. This can only be used where the source data has parent relations configured.

GetParentId(GetCurrentRow(),GetSourceData())

GetParentValue

Returns the value of a row’s parent. This can only be used where the source data has parent relations configured.

GetParentValue(‘ParentField’)

GetSourceData

Returns a data structure that contains all source tables. The result can be used by functions which need access to all incoming tables and their metadata.

GetSourceData()

GetTargetData

Returns a data structure that contains all destination tables. The result can be used by functions which need access to all destination tables and their metadata.

GetTargetData()