I need to do use a Group Node to do a lot of math across 695 columns and using the “Manual Aggregation” tab seems ludicrous in KNIME. The other complication is that the columns may change which would mean having to manage all these columns every time there is a change. For this reason, I added a prefix to each of either ZA- or MB- so that I should be able to use the “Pattern-Based Aggregation” tab.
The column names would be something like this:
MB-WC.Name Site Location
Although the prefix is fairly limited, what appears after the “.” is could be anything including some punctuation “()”.
Regex seems to be the most manageable way forward but my regex knowledge is rudimentary at best. I would really appreciate any suggestions.