hi,
I have following situation in splunk (see picture below).
I need following pattern in Splunk (see picture below).
I have different generic columns where the last part of the column-name (Suffix) is dynamic and unknown. I need to combine/merge this generic columns to one target-column. Within the target-column I want to calculate the average per generic field. I think the picture explains the situation very well.
Do you have a fixed number of suffixes? That is, are there only SuffixA, SuffixB and SuffixC?