Compute operations between columns

[Thyme]

Hi again,

quick question, is your 3rd line in the result table correct? I think you want the Baseline to be unchanged, but the last entry of Var2Baseline is different.

Now for the solution, do you remember what I initially had in mind for your previous question? I think you’ll need the “Group Column Loop Mechanism” here. Link:

Compute for column values based on conditional substrings in the column names

It’s funny that you ask, after posting I had this idea on how to generalise my solution and I went to the “kitchen” right away. Here it is: split into mean and kind columns unpivot everything into a single column, no extras calc mean for each group transpose reunite columns (resulting table has empty rows) This is not what I had in mind, however. Story thyme: While reading your question, I had this spark in my head: Group Loop Start. Except that it groups rows, not columns. I would have to e…

Since it’s late, I’ll just describe how it would be done. I can do a workflow tomorrow.

1. Extract Column Names, exclude non-baseline columns, string manipulation to get the Filter-Needle
2. Table Row to Variable Loop Start with the table containing the filter needles
3. Column Filter. Haystack is the original table. Enable RegEx/Wildcards
4. Math Formula (Multi Column): include all non-baseline columns and do “CurrentCol - Baseline” via RegEx (is that possible? not sure); don’t forget to replace the columns, don’t append (keeps the names)
5. Column Append Loop End
6. rename the non-baseline columns to get the proper names
7. Column Resorter

Sweet Dreams, T

edit: is “Column Group Loop” actually the correct name? not a native english speaker …