how to keep distinct values for a column

Viewed 16

I want to keep distinct values for the given column. Assume I have the following columns out of which I want distint values for the column Values. Here is the input

Name       Values      Desc
B          "1,2,1,3"   Sample desc 1
A          "3,1,3"     Sample desc 2
A          "4"         Sample desc 3

This is the output I`m expecting:

Name       Values      Desc
B          "1,2,3"     Sample desc 1
A          "3,1"       Sample desc 2
A          "4"         Sample desc 3

I have this query in place:

Table
| project Name, Values, Desc

Please help with how to write this kusto query.

0 Answers
Related