Difficulty summing one column while aggregating other columns
Summary
I am trying to take a file that has thousands of rows and dozens of columns and aggregating it to only 5 columns. I have successfully aggregated the 4 rows of identifying data using the 'for-each-group' mapping. However, I am having difficulty summing the original data from the 5th column while also using the other 4 columns to filter on, essentially performing a 'sumif' expression like in excel.
Version (include the version you are using, if applicable):
25.04.0
Tagged:
0