topic Re: eval with dynamic column names in Splunk Search

eval with dynamic column names

mschellhouse — Wed, 22 Nov 2017 14:35:14 GMT

I have a table of data as follows:
KPI / Base:(date1) / Test:(date1) / Test:(date2) / Test:(daten)
KPI1 / 1.5 / 1.8 / 1.2 / 1.7
KPI2 / 2.1 / 2.5 / 1.9 / 2.2

I need to be able to calculate the difference between each test column to base column using eval. The test column name is dynamic as it has the date that the test was executed.

How do I handle the fact that the test column names are dynamic? They will all contain Test, or some other consistent string.

Re: eval with dynamic column names

somesoni2 — Wed, 22 Nov 2017 14:41:31 GMT

Try something like this

your current search giving table in your ques
| rename Base* as Base
| foreach Test* [| eval "diff_<<MATCHSTR>>"=Base-'<<FIELD>>']

Re: eval with dynamic column names

mschellhouse — Wed, 22 Nov 2017 17:54:28 GMT

The rename didn't work but I got around that. The foreach and eval were very helpful. Thanks!