Format

This Snap provides fixed width formatting for the column values and writes binary data to the output view.

Fixed width format for columns has data where every field will have a fixed width. For those fields values where their width is less than the specified width, they will be padded with spaces. The field width is user configurable.

None.

Does not work in Ultra Pipelines.

Accounts are not used with this Snap.

Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Number of lines to skip at beginning of the data

Example: 2

Default value: 0

The character used to separate lines in the output. Enter "\n" to separate the lines with a new line character.

Default value: \n

This option specifies whether or not the Snap should write the field names while writing the formatted data to the output. 

Default value: Selected

Details to be filled for each field that is required in the output.

Required. Field name to be used while writing the header

Example:  

First Name

Last Name

Default value:  [None]

Required. Fixed width for the field. If the value for this field is less than the specified width, the value will be padded with spaces.

Example:  25

Default value:  [None]

Required. The format type to be performed on the field value when the field width is less than the specified width.

The options available include:

• [None]: Doesn't apply any formatting

• Prefix with spaces: Pads spaces at the left side of the field value

• Suffix with spaces: Pads spaces at the right side of the field value

Default value: [None]

Required. Action to be performed when the existing field value is larger than the specified width

The options available include:

• [None]: Doesn't apply any action

• Truncate at end: Truncates data at the end of the field value to set the field width to the specified width

• Write to error view: Writes the document to the error view without applying any action

Default value: [None]
 

Enabled: Lets you set the target value to null in case the source path does not exist. 
Disabled: Fails if the source path does not exist or ignores the record entirely or writes the record to the error view depending on the setting of the error view property.

Select one of the three modes in which the Snap executes. Available options are:

• Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

• Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

• Disabled: Disables the Snap and all Snaps that are downstream from it.

Default Value: Execute only


Example: Validate & Execute