Output Fixed - Data360_Analyze - 3.12

Data360 Analyze Server Help

Data360 Analyze
Product family
Product name
Data360 Analyze
Data360 Analyze Server Help
First publish date

Writes data to a fixed-width file using designated field positions. The field specification consists of colon (:) separated field entries. Each field entry is of the form: name,start position,size.

This node has been deprecated and will not be supported in a future release. As an alternative, the Output Fixed node can be used to provide similar functionality.



Click the folder icon and browse to the file to which you want to output the data, then click Choose.

To create a new file, click the folder icon and navigate to the folder where you want to output the file, then enter a name for the file in the Filename field and click Choose.

A value is required for this property.

Note: If you are using the server edition, the output file will be created on the Data360 Analyze server. If you wish to open the file, and you don't have access to the file system on the server, you will need to download the file onto your local machine. Please see the topic Downloading data from the server for more details.


Specify a colon-separated field specification. Each entry is of the form: name,start position,size.

For example: FirstName,0,10:LastName,10,20:Salary,30,10.

A value is required for this property.


Optionally specify a string or character that will separate consecutive rows or records in the output file.

Use \n for newline (Unix style), \r\n for carriage return newline (Windows style).

The default value is blank, in which case there will be no delimiter used, only the record width.


Optionally specify whether to write a single record header row of the field names (truncated to field width if necessary).

The default value is False.


Optionally specify the size of each record in bytes.

If unspecified, the record will be as long as the largest (start+size) specification in the FieldPositions.


Optionally specify a byte value used to pad data in fields that are not long enough for their specification. Use \<octal> notation to specify non-printable characters, for example, \0 is NUL, \40 is space.

The default value is \0.


Optionally specify what to output when the value of a field is NULL.

The default value is blank.


Optionally specify the behavior if the data in a field is longer than the field specification. Choose from:

  • Truncate - Truncates the field.
  • Truncate and Log - Truncates the field and records this action in the log file.
  • Error - An error is generated.

The default value is Truncate.

Inputs and outputs

Inputs: in1.

Outputs: None.