Fix record (destination ETL/ELT)

(1) The path and name of the destination file to be created. Paths below the installation directory of the Integration Server can be specified relatively with ./ Note: Variables, see (3), and placeholders, see tooltip, can be used.

(2) Displays the destination file.

(3) Selection of ETL/ELT variables.

(4) The line break used in the destination file.

(5) If this checkbox is set, each row created here is written as one row in the destination file. Otherwise, the length of a row created here must be specified and (4) is omitted.

(6) Specifies the indices (starting at 0) from which the individual fields are written. A tool for this is available via (7).

(7) See (6).

(8) This allows a header to be added with a wizard. Note: If a dynamic path/filename (1) is used and the checkbox Release resources created for further processing in the source data is set, then headers cannot be used.

(9) ETL/ELT source fields and custom ETL/ELT fields can be selected here.

(10) Index columns ($COL.1, $COL.2, etc.) can be selected here. See section Fix record (source ETL/ELT).

(11) ETL/ELT variables can be selected here.

(12) With this you can move selected data items (9), (10) and (11) to the right (13). With the symbol below, entries selected on the left can be assigned to existing entries on the right in order. Drag and drop is also possible.

(13) The structure of the row to be generated. See section Examples (ETL/ELT).

(14) Here the ETL/ELT source fields can be filled with test data to test the output.

(15) This is an expert setting (Scriptella) and can be ignored.