datatransfer-addjoin-method.md

title	description	ms.author	ms.date	ms.topic	author	ms.reviewer
DataTransfer.AddJoin(Integer, Integer) Method	Adds a field pair to be used to create a join condition which determines which rows to transfer, optional for same table transfers.	solsen	05/14/2024	reference	SusanneWindfeldPedersen	solsen

DataTransfer.AddJoin(Integer, Integer) Method

Version: Available or changed with runtime version 10.0.

Adds a field pair to be used to create a join condition which determines which rows to transfer, optional for same table transfers.

Syntax

 DataTransfer.AddJoin(SourceField: Integer, DestinationField: Integer)

Parameters

DataTransfer
 Type: DataTransfer
An instance of the DataTransfer data type.

SourceField
 Type: Integer
The source table field.

DestinationField
 Type: Integer
The destination table field.

Remarks

[!INCLUDEdata-transfer]

Use this method to create a join condition between tables when copying fields from one table to the other. For more information, see Transferring Data Bewteen Tables.

This method isn't needed when copying withing the same table.

Example

[!INCLUDEdata-transfer-example-copy-fields]

See Also

DataTransfer Data Type
Getting Started with AL
Developing Extensions