Filling
This operation fills empty values of a table by repeating values according to an index.
-
You can choose to fill values towards the future (to down) or towards the past (to up).
-
You have to choose an index to order rows in the table.
Values filled are visualized into brackets.
Sign ^ in front of value means completion towards the future.
Sign v in front of value means completion towards the past. -
3 completion types are available:
- Complet with previous value (PREVIOUS)
- Complet with value (VALUE)
- Complet with linear regression (slope) (LINEAR) ==> index has to be a date for this completion type
- 3 completion modes are available:
- Completion until last value (LAST)
- Completion: all (ALL)
- Completion with a time limit (TIME) ==> Each cell is filled until a certain time.
- The option "Make completion in another column" is on "Automatic" by default.
It means that MX choose to fill values in the same column (for raw variables, copy, groupby) or in another column (for java, mapping).
In this last case a new column is created with:
- "/in.down" or "/in.up" at the end of the importkey for complet all or complet until last value
- "in/downt" or "in.upt" at the end of the importkey for complet with time limit
- "in/downl" or "in.upl" at the end of the importkey for complet with linear regression
💡 If you want to fill values in another column for variables from copy and groupby, you can check it to YES.
Constants
You can create a constant using the "operation" window that can be used in other operations (Java computing, Lag Time, etc...).
For example, if you have fixed volumes for tanks or fixed distances for conveyor, you can create them as constants (value and description).
To have the created constants list you have to go to "Columns" and choose "manage constants».
To create several constants at the same time, you can copy and paste a list from an excel file.
Java Computing
The content is computed according of the values of other columns and a Java program. Various examples of Java calculations are available here Java for Mx Brain catalog
A Java Computing is created in 4 steps:
1/ Choose a Column name for the Java
2/ Available columns
Columns used in the calculation are chosen via "Available Columns" (it is possible to take the variable that we are currently creating). Drag these variables towards the list of desired columns for the computation.
The number of parameters is limited to approximately 150.
3/ Fill the Java Program
The content of the source cell is supplied by the 'strX' parameters, where X is the order number of the column in the list of used columns.
The result must be supplied by "return".
4/ Compilation
Java program has to be compiled for verification. If there are errors, you can see them in the Compilation result
Multiple Java Computing
If you have to create the same calculation for different variables, you can create a multiple Java Computing from your first Java computing.
💡 Multiple Java parameters can be copy-pasted from an Excel sheet.
Java Filter
The content is computed from the column value and a Java program.
The content of the source cell comes from the 'strX' parameters, where X is the order number of the column in the list of used columns.
The result must be 'return true;' if rows must be removed, or 'return false;' if rows must NOT be removed.