eval with dynamic column names

[mschellhouse]

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.

[somesoni2 · Accepted solution]

Try something like this

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

[mschellhouse]

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