Splunk Search

All fields from a lookup.csv file appear except the date field?

boris
Path Finder

All fields from a lookup.csv file appear as available search fields except the date field.

Here is how I defined the start_date field in my lookup.csv file:

'2012-03-12 20:10'

%Y-%m-%d %H:%M

So how can I get this start_date field to appear as a potential field in my searching here?

0 Karma
1 Solution

boris
Path Finder

After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

View solution in original post

0 Karma

boris
Path Finder

After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

0 Karma

boris
Path Finder

Thanks MarioM. After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

0 Karma

MarioM
Motivator

can you post an extract of your lookup.csv with the header?

Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...