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 (3)
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!

Admin Your Splunk Cloud, Your Way

Join us to maximize different techniques to best tune Splunk Cloud. In this Tech Enablement, you will get ...

Cloud Platform | Discontinuing support for TLS version 1.0 and 1.1

Overview Transport Layer Security (TLS) is a security communications protocol that lets two computers, ...

New Customer Testimonials

Enterprises of all sizes and across different industries are accelerating cloud adoption by migrating ...