- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SplnkUse
Path Finder
12-01-2021
03:30 PM
Hello
I am running a * search in an app and it returns several columns in the csv extract where a column is named 'source'.
I want to return the distinct values of 'source' but neither of the below work:
| values(source)
or
| distinct source
Any idea?
thanks!
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yuanliu

SplunkTrust
12-02-2021
12:00 AM
I want to return the distinct values of 'source' but neither of the below work:
| values(source)
or
| distinct source
values and distinct are not commands. Have you tried stats?
| stats values(source) dc(source)
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yuanliu

SplunkTrust
12-02-2021
12:00 AM
I want to return the distinct values of 'source' but neither of the below work:
| values(source)
or
| distinct source
values and distinct are not commands. Have you tried stats?
| stats values(source) dc(source)
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ITWhisperer

SplunkTrust
12-01-2021
03:47 PM
| dedup source
