Page tree
Skip to end of metadata
Go to start of metadata

Summary

Compiling Forecast, Real and Trend Data [Mix columns]: Once having calculated the day-of-the week or week's trend, you can use the Mix Columns operator to specify the time up to which trend data is required in the restatement of old data, and when the original forecast data is used.

Columns of the input table

ColumnValue Description
FromDate This is the From column of the input table
ToDateopt.This is the To column of the input table
Columns to be copiedAny These columns are copied into the target table.

Parameter

ParameterValue Description
Sources  Here you can specify which period is filled with data from which source.
Name of the result columnText The name of the result column.
Default: Result


Example: ...

Situation

...

Settings...
Result

...

Project-File...

Want to learn more?

 Settings

-

Columns of input table


ParameterValueOpt.DescriptionExample
@MERGEFROM

System.DateTime

---
@MERGETO

System.DateTime

opt.--
@COLS

System.Object

---

Parameter


ParameterValueOpt.DescriptionExample
@COLUMNCONFIG

System.String

---
@RESULTCOLUMN

System.String

---
@HAMMERDLG

System.String

opt.--

 Examples

Example 1: ...

...

Calculation methodSettingsResult
... 

 

 Troubleshooting
ProblemFrequent CauseSolutions
... 

...

Related topics

  • ...