Splunk Search

How to transform data base on the value of the field?

ChioNeng
Explorer

Hello all, 

I need to get the total each column of the date and create a new column that showing the date column base on the value of "PostingDate". Im trying around addtotals for this but i can't get my output. Many thanks in advance.

Input:

APPLICATIONSetLEVELPostingDate2020-052020-062020-072020-082020-09
App1A22020-0816544
App2B32020-0822222
App3C42020-0811111
App4D52020-08488107


Output:

APPLICATIONSetLEVELPostingDate2020-052020-062020-072020-082020-09Latest
App1A22020-08165444
App2B32020-08222222
App3C42020-08111111
App4D52020-0848810710
    81716171417
Labels (2)
0 Karma

Nisha18789
Builder

hi @ChioNeng , as per the data in the output table, | addcoltotals will be able to help. However, I do see a latest column in the end but you have not mentioned about it in the question, is it something you are trying to achieve as well?

richgalloway
SplunkTrust
SplunkTrust

Please share your query that uses addtotals. Have you tried addcoltotals?

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...

Splunk App Dev Community Updates – What’s New and What’s Next

Welcome to your go-to roundup of everything happening in the Splunk App Dev Community! Whether you're building ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...