Drop Down based on its filename

Azwaliyana — Mon, 15 Nov 2021 02:01:18 GMT

I have a filename like this

-11112021_MOS.csv

-12112021_MOS.csv

-13112021_MOS.csv

I want to create drop down based on the date. How can I do that?

Re: Drop Down based on its filename

kamlesh_vaghela — Mon, 15 Nov 2021 04:54:29 GMT

@Azwaliyana

As per my understanding, you need to filter dropdown values (files) on the basis of the date defined in the file name on. change of timerange. then try below search in your dropdown.

YOUR_SEARCH | eval file_date= strptime(Filename,"%d%m%Y_MOS.csv") | addinfo | where file_date>=info_min_time and file_date<info_max_time

My Sample Search :

You have have different use case then please share more details on it.

Thanks
KV
▄︻̷̿┻̿═━一 😉

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

topic Drop Down based on its filename in Getting Data In

Drop Down based on its filename

Re: Drop Down based on its filename