The clipboard passes data to sibling tasks. Sibling tasks sit at the same level below a task in the task list. This detour can be necessary. Only child tasks can access the ETL/ELT fields of parent tasks. For each processed line, the task creates one line in the clipboard.
Settings
In the parent task, you select ETL/ELT fields. These fields define the structure of a row in the clipboard. In child tasks, you access the clipboard in two places: through the source data type Clipboard (source ETL/ELT) and when defining custom ETL/ELT fields.
Specify at least two ETL/ELT fields. One field serves as the search column to find the row you need. The second field returns the value from that row. Both linked sections describe the access in detail.
NOTE If an ETL/ELT task has a clipboard entry, you can tell by an icon in the task list. You can find a practical example in the section Examples (ETL/ELT).