Oh okay I just assumed it was a Splunk lookup. So if you are indexing the data from a CSV then you can probably do something like this (assuming field extractions are in place) index=<index> sourcetype=<sourcetype>
| table
[
| makeresults
| fields - _time
| eval
ID=[ | search index=<index> sourcetype=<sourcetype> | stats latest(ID) as ID | return $ID ],
field_list_id_zero="NAME,STATUS,DATE,ACTION",
field_list_id_positive="DATE-Changed,ID,NAME,DATE_DOWN,ACTION",
final_field_list=if(
'ID'==0,
'field_list_id_zero',
'field_list_id_positive'
)
| fields + final_field_list
| return $final_field_list
] where <index> and <sourcetype> is where your CSV is being indexed.
... View more