Versions Compared

Old Version 11

changes.mady.by.user Chandna Mitra

Saved on

compared with

New Version 12

changes.mady.by.user Chandna Mitra

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On this Page

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information

Snap type:

Format


Description:

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.


Prerequisites:

[None].


Support and limitations:Ultra pipelines: Does not work

Works in Ultra Pipelines

. Spark mode: Not supported in /wiki/spaces/SD/pages/1437917 mode

.

Account: 

Accounts are not used with this Snap.


Views:


InputThis Snap has exactly one document input view, where it will receive the document data to be formatted into Fixed width binary data.
OutputThis Snap has exactly one binary output view, where it provides a binary data stream containing the fixed width data.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.


Settings



Label


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.

Skip lines



Number of lines to skip at beginning of the data

Example: 2

Default value: 0


Line separator


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

Default value: \n


Add header


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

Default value: Selected


Field configuration

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


Input field

Required. Field name to be used while writing the header

Example:  

First Name

Last Name

Default value:  [None]


Field width

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]


Format type

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]


Action

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]
 

Null-safe access


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.


Multiexcerpt include macro
nameSnap Execution
pageAnaplan Read

Multiexcerpt include macro
nameSnap_Execution_Introduced
pageAnaplan Read


Insert excerpt
Transform Snap Pack
Transform Snap Pack
nopaneltrue