tFileOutputDelimited Standard properties
These properties are used to configure tFileOutputDelimited running in the Standard Job framework.
The Standard
tFileOutputDelimited component belongs to the File family.
The component in this framework is generally available.
Basic settings
Property type |
Either Built-In or Repository. |
|
Built-In: No property data stored centrally. |
|
Repository: Select the repository file where the |
Use Output Stream |
Select this check box process the data flow of The data flow to be processed must be added to the flow in order for this component to fetch This variable could be already In order to avoid the inconvenience of For further information about how to use a stream, |
File name |
Name or path to the output file and/or the variable This field becomes unavailable once you have For further information about how to define and use a |
Row Separator |
The separator used to identify the end of a row. |
Field Separator |
Enter character, string or regular expression to separate fields for the transferred |
Append |
Select this check box to add the new rows at the end |
Include Header |
Select this check box to include the column header to |
Compress as zip file |
Select this check box to compress the output file in |
Schema and Edit schema |
A schema is a row description. It defines the number of fields (columns) to Click Edit schema to make changes to the schema.
This component offers the This dynamic schema |
|
Built-In: You create and store the |
|
Repository: You have already created |
Sync columns |
Click to synchronize the output file schema with the |
Advanced settings
Advanced separator (for numbers) |
Select this check box to change the separator used for numbers. By default, the thousands separator is a comma (,) and the decimal separator is a period (.).
Thousands separator: define separators
Decimal separator: define separators for |
CSV options |
Select this check box to specify the following CSV parameters:
|
Create directory if not exists |
This check box is selected by default. It creates the directory |
Split output in several files |
In case of very big output files, select this check box to
Rows in each output file: set the number |
Custom the flush buffer size |
Select this check box to define the number of lines to write
Row Number: set the number of lines to |
Output in row mode |
Select this check box to ensure atomicity of the flush so that This check box is mostly useful when using this component in |
Encoding |
Select the encoding from the list or select Custom and define it manually. This field is compulsory for database |
Don’t generate empty file |
Select this check box if you do not want to generate empty |
Throw an error if the file already exist |
Select this check box to throw an exception if the output file specified in the Clear this check box to overwrite the existing file. |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
FILE_NAME: the name of the file being processed. This is
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
Use this component to write |
Limitation |
Due to license incompatibility, one or more JARs required to use this component are not |