This one is primarily about Regex.
It is one more example of wanting specificity and accuracy in the data request (prompt).
I was able to achieve the final answers with relatively few tools. Took at least that many again to get everything to line up the way that the solution wanted.
I did eventually figure out that Task 1 is asking you to group by the workflow. To be clear here - while you ARE expected to produce one row for each log file it is the case that any aggregation that you do should be grouped by the workflow name rather than by the log file.
Learnings:
Sometimes combining two outputs of the Join tool is really useful before you move on.
Clarifying the desired output *BEFORE* you start can save a lot of time and hassle.
Sometimes, if you are starting at A and trying to get the correct data out of C and you know that B is 1-1 mapped to C then you can find the C data by using A to get to B. Just be careful because that can cause problems if the data structure changes.
