Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Group events based on similar content in text fields.
...
Example
Input
table = github_logs
id | address |
---|---|
1 | 154 E. Dana st, Mountain View, CA, USA |
2 | 154 Data, Mountain View, CA, 94041 |
3 | Somewhere in Houston, TX |
4 | 14054 San ramon st, Houston, TX, 77077 |
LQL command
Code Block |
---|
formClusters(table, ["address"], 2) |
Output
id | address | lhub_cluster_id |
---|---|---|
1 | 154 E. Dana st, Mountain View, CA, USA | cluster_1 |
2 | 154 Data, Mountain View, CA, 94041 | cluster_1 |
3 | Somewhere in Houston, TX | cluster_0 |
4 | 14054 San ramon st, Houston, TX, 77077 | cluster_0 |