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.
1.csv (loading date yesterday)
2.csv (loading date today)
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.