| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Obtain counts of the number of distinct values in each column. The output reports the column names and number of distinct values in each column.
...
| Code Block |
|---|
fieldnamesHistogram(table) -- Note: fieldnames those are used internally are omitted: lhub_id, lhub_page_num, lhub_ts, lhub_session |
Example
Input
id | col1 | col2 |
|---|---|---|
1 | x | a |
2 | x | b |
3 | x | a |
LQL command
| Code Block |
|---|
fieldnamesHistogram(table) |
Output
Fieldname | DistinctCount |
|---|---|
id | 3 |
col2 | 2 |
col1 | 1 |