Package | Description |
---|---|
net.pricefx.formulaengine | |
net.pricefx.formulaengine.scripting | |
net.pricefx.server.dto.calculation |
Modifier and Type | Method and Description |
---|---|
Matrix2D |
TableContext.executeQuery(Query query) |
Matrix2D |
TableContext.executeQuery(String queryString) |
Matrix2D |
DatamartContext.executeSqlQuery(String sql,
Object... sources)
Executes an ANSI compliant SQL SELECT statement in the PA DB.
Important note: a non-compliant statement that does not fail at the present time, may well fail in future releases. The DB schema that can be queried is constructed on the fly by means of view definitions. |
Matrix2D |
DatamartQueryResult.getData()
Retreives the query result data.
|
Matrix2D |
TableContext.select(String selectSql)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
Matrix2D |
Matrix2D.addColumn(String colLabel)
Add a column to this Matrix2D, without any values
|
Matrix2D |
Matrix2D.addColumn(String colLabel,
Object[] colValues)
Add a column to this Matrix2D, with the value on each row retreived from the given values array.
|
Matrix2D |
Matrix2D.addMappedColumn(String colLabel,
List<String> fromColLabels,
Map<MultiKey<String>,Object> mapping)
Add a column to this Matrix2D, with the value on each row looked up from the given map, using a set of existing columns' values as a composite lookup key.
|
Matrix2D |
Matrix2D.addMappedColumn(String colLabel,
String mappedColLabel,
Map<String,Object> mapping)
Add a column to this Matrix2D, with the value on each row looked up from the given map, using the mapped column's value as the lookup key.
|
Matrix2D |
Matrix2D.indexOfMax() |
Matrix2D |
Matrix2D.indexOfMin() |
Matrix2D |
Matrix2D.max() |
Matrix2D |
Matrix2D.mean() |
Matrix2D |
Matrix2D.min() |
Matrix2D |
Matrix2D.normalize(long... cols)
Normalizes numeric column values, by dividing each value in the column by the total for the column.
|
Matrix2D |
Matrix2D.normalizeRowValues(Collection<String> colLabels,
int precision)
Normalizes the values on a row-by-row basis.
|
Matrix2D |
Matrix2D.renameColumns(Map<String,String> old2NewColLabels)
Renames the columns in this matrix so that the old column label = key, and the new column label = value in the given map.
|
Matrix2D |
Matrix2D.replaceMissingValues(String colLabel,
Object val)
Replaces nulls in the given column with the given value.
|
Matrix2D |
Matrix2D.select(long startRow,
long endRow,
long startColumn,
long endColumn)
Selects a subset of rows and columns in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectColumn(long col)
Selects a column in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectColumn(String label)
Selects a column in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectColumns(long startCol,
long endCol)
Selects a subset of columns in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectRow(long row)
Selects one row in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectRows(Collection<? extends Number> rows)
Selects a subset of rows in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectRows(long[] rows)
Selects a subset of rows in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.selectRows(long startRow,
long endRow)
Selects a subset of rows in the matrix, and returns the result as new Matrix2D object, but which crucially does not duplicate any of the original rows.
|
Matrix2D |
Matrix2D.sortRows(long col) |
Matrix2D |
Matrix2D.sortRowsReverse(long col) |
Matrix2D |
Matrix2D.std() |
Matrix2D |
Matrix2D.sum() |
Modifier and Type | Method and Description |
---|---|
Matrix2D |
ResultMatrix.toMatrix2D() |
Copyright © 2019. All rights reserved.