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, an upvote would be appreciated.
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!