Forum Discussion
Summarize // remove duplicate
If I have 10 columns and Ii use summarize on more than few, it complains of too many columns.
Also I only want to remove duplicates in 1 column while still retaining all other columns in output. How can I accomplish this.
1 Reply
- You probably want to use the take_any operator from summarize (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/take-any-aggfunction) Something link | summarize take_any(*) by DuplicatedColumn
