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).

Settings

(1) SQL query on clipboard: The query "SELECT * FROM @CLIPBOARD_TABLE@" 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@'.

(2) Format SQL: Self-explanatory.