...
fieldnamesStatistics provides detailed information on the column for the input table.
Operator Usage in Easy Mode
- Click + on the parent node.
- Enter the Fieldnames Statistics operator in the search field and select the operator from the Results to open the operator form.
- In the Input Table drop-down, enter or select the table on which this operator runs to generate the statistics.
- Click Run to view the result.
- Click Save to add the operator to the playbook.
- Click Cancel to discard the operator form.
Usage Details
LQL Command
Code Block |
---|
fieldnamesStatistics(inputTable: TableReference, valuesLimit:Long) |
...
A table containing the column names and their statistics, for example, non null count, distinct count, min, max, mean, and stdev.
Example
Input
name | ID | floatVal | IP | longVal |
---|---|---|---|---|
test | 1 | 12.32 | 12.32.43.41 | 1341235253 |
lhub | 2 | 10.5 | 10.32.43.41 | 1341230253 |
...