Getting Data In
Highlighted

Updating based on column

Path Finder

Hi All,

I have a configured a folder to read csv files.
My csv files column will be in same format.
Consider I have 2 csv say 1 and 2.These excels are loaded into folder at different dates.
Example.
1.csv (loading date yesterday)
Id Status
1 DEV
2 QA
2.csv (loading date today)
Id Status
1 PROD
2 PROD

Instead of splunk showing all the data I want to show the last status of an Id.
Ie since the status of id's 1 and 2 are changed to PROD i want to show that status only.
Is it possible.
One option i can see is search the column with latest time.
Did we have any configuration we can set at data loading time itself to achieve this.

0 Karma
Highlighted

Re: Updating based on column

Champion

How is STATS?

・・・・|stats last(Status) as Status by Id

0 Karma
Highlighted

Re: Updating based on column

Path Finder

Yes it worked.Instead of last I give first.

0 Karma
Highlighted

Re: Updating based on column

Champion

I'm sorry. It was FIRST.

・・・・|stats first(Status) as Status by Id

0 Karma