topic Re: Updating based on column in Getting Data In

Updating based on column

jimjohn — Thu, 06 Mar 2014 06:54:53 GMT

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.

Re: Updating based on column

HiroshiSatoh — Thu, 06 Mar 2014 10:39:38 GMT

How is STATS?

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

Re: Updating based on column

jimjohn — Thu, 06 Mar 2014 11:15:11 GMT

Yes it worked.Instead of last I give first.

Re: Updating based on column

HiroshiSatoh — Thu, 06 Mar 2014 11:44:54 GMT

I'm sorry. It was FIRST.

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