Custom ETL/ELT fields
You can also create your own ETL/ELT fields in addition to the ETL/ELT source fields. To do this, use the context menu in the corresponding tab.
These custom ETL/ELT fields can then be used like ETL/ELT source fields when generating the destination data row.
Source column
(1) Define field: The name of your custom ETL/ELT field.
(2) Source column/Expression: Here you can select an ETL/ELT source column (COL.1 for column 1, etc.). For the source data types XML and JSON, you can also use XPath or JSONPath expressions here, which are then applied to the internally read-in subtree, see sections XML (source ETL/ELT) and JSON (source ETL/ELT). Examples: /title/@lang (XPath) and .book[2].category (JSONPath).
Functions
(1) Define field: The name of your custom ETL/ELT field.
(2) There is a specific parameter type for ETL/ELT source fields.
(3) The result of the function chain is the value of your custom ETL/ELT field.
Fix value
(1) Define field: The name of your custom ETL/ELT field.
(2) Fix value: The fix value for this field.
Clipboard
In order to use this variant, 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).
(1) Define field: The name of your custom ETL/ELT field.
(2) Search column: The name of the ETL/ELT field (column) in the clipboard row that is compared with the specified search value (3).
(3) Search value: The value that is compared with the search column (2).
(4) Result of ETL/ELT field: The name of the ETL/ELT field (column) in the clipboard row whose value is used as the value of your custom ETL/ELT field (1). In summary, your custom ETL/ELT field parent_points therefore receives the value of the column Points from the row in the clipboard whose column Lastname has the value Hammer.