File Load

With file load, data from the source is loaded into a file (connection type "file") in CSV format.

Settings

Data source	Extract or transform containing the data to be written.
Tree format	If the data source is a tree, the hierarchy format must be entered. See Overview of Tree Formats.
Target connection	The file connection to be used.
Mode	create File is created new. At the top, "skip lines" empty lines are written. add Data is appended to the end of an existing file. Before the data, empty lines corresponding to the number specified by "skip lines" are written. insert Data is inserted in an existing file at the line with the number specified by "skip lines". Existing lines below move to the end. update Data is inserted in an existing file at the line number specified by "skip lines". Existing lines are overwritten. Note: file load with target file location "JedoxFiles" is only supported on "create" mode, i.e. it does not work on "add" and "update" modes.
Skip lines	The number of empty or skipped lines before writing the data (depending on the load mode).
Do not generate empty file	If checked, rows that do not contain data will not generate an element. If not checked, such rows will generate an element with null value.
Default value	Adds a constant string if the column value is null. Not applicable if the column contains an empty string.
Use scientific notation	Boolean option to display data with (default) or without scientific notation. If set, results use exponential notation for very high/low numbers. If not set, results use decimal notation with precision up to 15 digits.

If the file does not exist before the load, the result is the same as with any load mode.

Updated September 27, 2022