Examples of Common Value Generation

Auto increment

Description

This method generates a new value each time it is called. Internally, it uses a database sequence that provides incrementing values.

Input type

COLUMN

Parameters
Display name Description Variable name Data type Default value Possible values

Sequence Name

Specifies the name of the sequence.

sequenceName

STRING

AUTO_INCREMENT

-

IncrementBy

Specifies the step size of the sequence. Negative values will lead to a down counting sequence.

incrementBy

STRING

-

-

Start Value

Specifies the value the sequence is starting with.

startValue

STRING

-

-

Min Value

Specifies the lower limit of the sequence. This will be used as start value or at cycling.

minValue

STRING

-

-

Max Value

Specifies the maximum value for the sequence. This will be used as start value for down counting sequences.

maxValue

STRING

-

-

Cycle

Specifies whether the sequence cycles at the borders or causing an error.

cycle

BOOLEAN

FALSE

-

Drop Sequence

Specifies if the sequence is dropped at the end of the modification method finishes.

dropSequence

BOOLEAN

FALSE

-

Modify time data

Description

Change a time data value by modifying it or generate or set a new value. Input can be a date, time, timestamp or string column. This method internally parses each of the input values to a timestamp and then allows to modify each part of this timestamp separately. For each of the parts (year, month, day, hour, minute, second, fractions) one of the following values can be specified: * <value> → Set the specified value

  • +<value> → to add the specified amount to this part

  • -<value> → to subtract a specified amount from this part

  • NOW → take the value of the current timestamp

  • NOW+<value> → to add a given amount to the current timestamps part and use it

  • NOW-<value> → to subtract a given amount from the current timestamps part and use it

  • SEED(<min>:<max>) → Generate a new value for this part based on a given seed. The seed can be a column name of the table to use the columns value. Otherwise the seed value will be used as it is. The part in brackets is optional and can limit the range of the generated value. <min> → specifies the low limit for the generated value. <max> → specifies the high limit for the generated value. Both <min> and <max> are optional. If not specified the default value for the limit will be used. The seed value has to be specified in parameter seed.

  • +SEED(<min>:<max>) → Generate a new value like SEED(<min>:<max>) but this value will be added to the current value of the part.

  • -SEED(<min>:<max>) → Generate a new value like SEED(<min>:<max>) but this value will be subtracted from the current value of the part.

  • RAND(<min>:<max>) → Generate a new random value. The part in brackets is optional and can limit the range of the generated value. <min> → specifies the low limit for the generated value. <max> → specifies the high limit for the generated value. Both <min> and <max> are optional. If not specified the default value for the limit will be used. The default limits depend on the part of the timestamp.

  • +RAND(<min>:<max>) → Generate a new value like RAND(<min>:<max>) but this value will be added to the current value of the part.

  • -RAND(<min>:<max>) → Generate a new value like RAND(<min>:<max>) but this value will be subtracted from the current value of the part.

Input type

COLUMN

Parameters
Display name Description Variable name Data type Default value Possible values

Year

The rule or value that will be used to build a new year value for the given time data. The possible rules are described in the methods descriptions.

year

STRING

-

-

Month

The rule or value that will be used to build a new month value for the given time data. The possible rules are described in the methods descriptions.

month

STRING

-

-

Day

The rule or value that will be used to build a new day value for the given time data. The possible rules are described in the methods descriptions.

day

STRING

-

-

Hour

The rule or value that will be used to build a new hour value for the given time data. The possible rules are described in the methods descriptions.

hour

STRING

-

-

Minute

The rule or value that will be used to build a new minute value for the given time data. The possible rules are described in the methods descriptions.

minute

STRING

-

-

Second

The rule or value that will be used to build a new second value for the given time data. The possible rules are described in the methods descriptions.

second

STRING

-

-

Fraction

The rule or value that will be used to build a new fraction value for the given time data. The possible rules are described in the methods descriptions.

fraction

STRING

-

-

Seed

Specify the seed which can be used to generate new values for the time data parts. If a column name is specified the value of this column will be used as seed.

seed

STRING

-

-

FormatPattern

When the input value is a string this pattern will be used to parse the value of this string into a timestamp and to format the output into the same format.

formatPattern

STRING

yyyy-MM-dd-HH.mm.ss

-

FractionPattern

When the input value is a string this pattern will be used to parse the value of this string into the fractions part of the timestamp and to format the output into the same format.

fractionPattern

STRING

.SSSSSSSSSSSSZ

-

IgnoreNullInputs

Specify if null value inputs should be ignored. If set to false new values are generated for null inputs.

ignoreNull

BOOLEAN

true

-

IMEI

Description

Generates an IMEI based on an existing IMEI and the specified seed value.

Input type

COLUMN

Parameters
Display name Description Variable name Data type Default value Possible values

Seed

Specifies the value that is used to calculate the hash.

seed

STRING

-

-

Restart sequence

Description

This modification method reads the highest value of the selected column of the table and adds 1 to this value. "Then the selected column of the target table restarts with this value. On this way it is avoided that "the current sequence number will ever be reached what would cause loss of data. "You have to select the primary key-column in the linked modification set for the correct usage.

Input type

COLUMN

Pattern

Description

Generates a sequence of letters and digits according to a pattern.The letter 'A' is replaced by a letter from A to Z.The digit '9' is replaced by a digit from 0 to 9.The letter 'N' is replaced by either a letter or a digit.The letter 'X' is replaced by a hexadecimal digit (0 to F).All other characters are preserved as they are.

Input type

COLUMN

Parameters
Display name Description Variable name Data type Default value Possible values

Seed

Specifies the value that is used to calculate the hash.

seed

STRING

-

-

Pattern

The pattern string based upon which the resulting sequence of letters and digits will be calculated.

pattern

STRING

-

-

Set Value

Description

Sets the specified value to the column.

Input type

COLUMN

Parameters
Display name Description Variable name Data type Default value Possible values

New Value

The new value to be set.

newValue

STRING

-

-