Formulas
The following are the available values for the columns[].formula.name and columns[].formula.args fields in Schema.
For example,
| Name | Description | Type | Args |
|---|---|---|---|
AddInt | Sum up int | int | List of columns containing int.For example, ["schema1.col1", "schema2.col2", ...] |
AddFloat | Sum up float | float | List of columns containing float.For example, ["schema1.col1", "schema2.col2", ...] |
AddString | Concatenate string | string | List of columns containing string.For example, ["schema1.col1", "schema2.col2", ...] |
And | Apply && Operator | bool | List of columns containing bool.For example, ["schema1.col1", "schema2.col2", ...] |
Or | Apply || Operator | bool | List of columns containing bool.For example, ["schema1.col1", "schema2.col2", ...] |
XOrInt | Apply | Operator | int | List of columns containing int.For example, ["schema1.col1", "schema2.col2", ...] |
Copy | Copy value from given column | any | One column. For example, ["schema1.col1"] |
CurrentTimeMs | Current time in Unix milliseconds | int64 | [] |
ToUnixMilli | Convert date like 2006-01-02 to Unix milliseconds | int64 | One column. For example, ["schema1.col1"] |
AddRandomTimeMs | Copy value from given column, and add a random number between minimum and maximum to it | int64 | One column, a minimum integer in string, and a maximum integer in string. For example, ["schema1.col1", "-100", "100"] |
AddRandomNumber | Copy value from given column, and add a random number between minimum and maximum to it | int | One column, a minimum integer in string, and a maximum integer in string. For example, ["schema1.col1", "-100", "100"] |