Clipboard (source ETL/ELT)

Prev Next

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

Settings

images/download/attachments/201681777/clipboard-version-1-modificationdate-1749453956815-api-v2.png

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