I have a table with about 10 columns in which 1 of those columns (Project Number) has data that I can group by and 1 column has dates (Edited Date).
I can use the GroupBy node to add Project Number in the ‘Groups’ tab and add Edited Date column in the ‘Manual Aggregation’ tab and selecting ‘Maximum’ as the aggregation.
All that is good.
But I don’t know how to then also include all the other columns in my final dataset.
I can’t add all the other columns to the ‘Groups’ tab because it does funky things.
I just want to return a record with all 10 columns where I am taking the latest date based on the Project Number.
I’m stuck on what to do after the GroupBy node in my workflow.
EDIT: Should I just use a JOINER node to join the other 8 columns I need based on PROJECT NUMBER and EDITED DATE as the identifiers to match?
Thanks heaps for any help.