Clipboard (source ETL/ELT)

(1) The clipboard (see details there) must have been filled in previous tasks. For this example, we assume that the clipboard was filled with the ETL/ELT source fields Firstname, Lastname and Points. See also section Examples (ETL/ELT).

(2) The SQL query on the clipboard. The query shown would return all rows of the clipboard, but it can also be restricted with a WHERE condition, e.g. with WHERE Lastname='Hammer' or via ETL/ELT variable with WHERE Lastname='@NAME@'.