Splice

Syntax

Splice(Output: ITimeSeries,
      Input: ITimeSeries,
       Method: MsSpliceType,
       Direction: MsSpliceDirection,
       BoundByDates: Boolean,
       StartDate: String,
       EndDate: String)

Parameters

Output. Output variable.

Input. Variable that is spliced with the output one.

Method. Splice method.

Direction. Splice direction. Optional parameter. By default the parameter is set to MsSpliceDirection.Both - both sides.

BoundByDates. The parameter determines whether to use the start (StartDate) and end dates (EndDate) of series splice. Optional parameter. The parameter is set to False by default.

StartDate. Start date of series splice. Optional parameter. Default value is not set.

EndDate. End date of series splice. Optional parameter. Default value is not set.

Description

It splices variables.

Comments

Available values of the BoundByDates parameter:

Example

Formula Result Application
= Splice({Brazil|BCA},{China|BCA}, MsSpliceType.Pch, MsSpliceDirection.Backward,False)

Values of Brazil|BCA and China|BCA factors are spliced by the splice method of data with rates of change in backward direction.

It can be used in formulas of calculated series of time series database and model formulas of modeling container that is a child of the time series database.
= Splice(X1,X2,MsSpliceType.Butt, MsSpliceDirection.Both, True,"01.01.2002","01.01.2007")

Values of X1 and X2 factors are spliced from 2002 to 2007.

It can be used in model formulas of modeling container.

See also:

Functions Available in Expression Editor │ TransformationsIModelling.Splice