Splunk Search

How to consolidate this data

k31453
Explorer

Hi, I have two entries for this productid, Is it possible to consolidate to one entry maybe with evals?

productidfield1field2field3
abctest  
abc week13

 

Labels (1)

to4kawa
SplunkTrust
SplunkTrust

|selfjoin productid

ITWhisperer
Ultra Champion
| stats values(*) as * by productid
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!