Hi, I am a newbie to SPL and would like some help. I want to find the latest date field in my lookup file file. My test.csv file look like this name,size,datum AA,11,12-09-2020 AA,18,14-09-20...
See more...
Hi, I am a newbie to SPL and would like some help. I want to find the latest date field in my lookup file file. My test.csv file look like this name,size,datum AA,11,12-09-2020 AA,18,14-09-2020 AB,33,15-04-2020 AB,34,16-04-2020 AB,35,15-06-2020 AC,23,14-05-2020 AC,14,08-07-2020 If i want to find the maximum value of column "size" i succeed |inputlookup test.csv | eval foo=[ |inputlookup test.csv |stats max(size) as dtx | return $dtx ] | table foo Result: 35 35 .. But when i try this with the date value i get this |inputlookup tabs.csv | eval foo=[ |inputlookup tabs.csv |stats max(datum) as dtx | return $dtx ] | table foo i get -2008 -2008 .. How to i match the latest date value ? Thank you in advance. Reagrds, Harry