Numeric Routines - 6.2

Talend Data Fabric Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

To access these routines, double click on the Numeric category, in the system folder. The Numeric category contains several routines, notably sequence, random and decimal (convertImpliedDecimalFormat):

Routine

Description

Syntax

sequence

Returns an incremental numeric ID.

Numeric.sequence("Parameter name", start value, increment value)

resetSequence

Creates a sequence if it doesn't exist and attributes a new start value.

Numeric.resetSequence (Sequence Identifier, start value)

removeSequence

Removes a sequence.

Numeric.RemoveSequence (Sequence Identifier)

random

Returns a random whole number between the maximum and minimum values.

Numeric.random(minimum start value, maximum end value)

convertImplied DecimalFormat

Returns a decimal with the help of an implicit decimal model.

Numeric.convertImpliedDecimalFormat ("Target Format", value to be converted)

The three routines sequence, resetSequence, and removeSequence are closely related.

  • The sequence routine is used to create a sequence identifier, named s1 by default, in the Job. This sequence identifier is global in the Job.

  • The resetSequence routine can be used to initialize the value of the sequence identifier created by sequence routine.

  • The removeSequence routine is used to remove the sequence identifier from the global variable list in the Job.

How to create a Sequence

The sequence routine allows you to create automatically incremented IDs, using a tJava component:

System.out.println(Numeric.sequence("s1",1,1)); 
System.out.println(Numeric.sequence("s1",1,1));

The routine generates and increments the ID automatically:

How to convert an Implied Decimal

It is easy to use the convertImpliedDecimalFormat routine, along with a tJava component, for example:

System.out.println(Numeric.convertImpliedDecimalFormat("9V99","123"));

The routine automatically converts the value entered as a parameter according to the format of the implied decimal provided: