tFileInputMSPositional Standard properties - Cloud - 8.0

MS Positional

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > File components (Integration) > MS Positional components
Data Quality and Preparation > Third-party systems > File components (Integration) > MS Positional components
Design and Development > Third-party systems > File components (Integration) > MS Positional components
Last publication date
2024-02-20

These properties are used to configure tFileInputMSPositional running in the Standard Job framework.

The Standard tFileInputMSPositional component belongs to the File family.

The component in this framework is available in all Talend products.

Basic settings

Property type

Either Built-in or Repository.

 

Built-in: No property data stored centrally.

 

Repository: Select the repository file where the properties are stored. The fields that follow are completed automatically using the data retrieved.

File name/Stream

Name of the file and/or the variable to be processed

For further information about how to define and use a variable in a Job, see Using contexts and variables.

Warning: Use absolute path (instead of relative path) for this field to avoid possible errors.

Row separator

String (ex: "\n"on Unix) to distinguish rows.

Header Field Position

Start-end position of the schema identifier.

Records

Schema: define as many schemas as needed.

Header value: value in the row that identifies a schema.

Pattern: string which represents the length of each column of the schema, separated by commas. Make sure the values defined in this field are relevant with the defined schema.

Reject incorrect row size: select the check boxes of the schemas where to reject incorrect row size.

Parent row: Select the parent row from the drop-down list. By default, it is <Empty>.

Parent key column: Type in the parent key column name. If the parent row is not <Empty>, this field must be filled with a column name of the parent row schema.

Key column: Type in the key column name.

Skip from header

Number of rows to be skipped in the beginning of file.

Skip from footer

Number of rows to be skipped at the end of the file.

Limit

Maximum number of rows to be processed. If Limit = 0, no row is read or processed.

Die on parse error

Let the component die if an parsing error occurs.

Die on unknown header type

Length values separated by commas, interpreted as a string between quotes. Make sure the values entered in this fields are consistent with the schema defined.

Advanced settings

Process long rows (needed for processing rows longer than 100,000 characters wide)

Select this check box to process long rows (this is necessary to process rows longer than 100 000 characters).

Advanced separator (for numbers)

Select this check box to modify the separators used for numbers:

Thousands separator: define separators for thousands.

Decimal separator: define separators for decimals.

Trim all column

Select this check box to remove leading and trailing whitespaces from defined columns.

Validate date

Select this check box to check the date format strictly against the input schema.

Encoding

Select the encoding type from the list or select Custom and define it manually. This field is compulsory for DB data handling.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at a Job level as well as at each component level.

Global Variables

Global Variables

NB_LINE: the number of rows read by an input component or transferred to an output component. This is a Flow variable and it returns an integer.

NB_LINE_REJECTED: the number of rows rejected. This is a Flow variable and it returns an integer.

NB_LINE_UNKOWN_HEADER_TYPES: the number of rows with unknown header type. This is a Flow variable and it returns an integer.

NB_LINE_PARSE_ERRORS: the number of rows with parse errors. This is a Flow variable and it returns an integer.

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it.

For more information about variables, see Using contexts and variables.

Usage

Usage rule

Use this component to read a multi schemas positional file and separate fields using a position separator value. You can also create a rejection flow using a Row > Reject link to filter the data which does not correspond to the type defined. For an example of how to use these two links, see Procedure.