File Load


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

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

Target connection




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.

Advanced settings

Skip lines

The number of empty or skipped lines before writing the data (depending on the load mode).

Do not generate empty file

Default: False

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