Filter Map After Aggregate and Group By in Data Processing

·Dec 11, 2025 11:23 PM·

Share

Filter in map after aggregate & group by By: Milo Parsons Hi, I am using an Aggregate step with a Group By and I am trying to get a value based on another object's value. e.g. in the below example, I'd like to return the last_updated value where status = complete i.e. "2025-01-01" I tried this but it just returns true/false: $status == "Complete" ? $last_updated : null ``` [ { "status": "Complete", "last_updated": "2025-01-01" }, { "status": "Pending", "last_updated": "2025-05-01" } ] ``` Any help would be much appreciated! Thanks

1 comment

· Sorted by Oldest

Scott O.
·
·
By: Spiro Taleski $.filter(x => x.status == "Complete") It will produce new array containing only the objects where status = Complete. The expression will work only if the input data is array. I guess that, in your case the data is already split before the step where the expression is put (and that's the reason why it is not working). If your data is already split, then you can filter the records using Filter Snap with the following expression: $status == 'Completed' So only records with status = Completed will be sent further.

Scott O.
·
·
By: Spiro Taleski $.filter(x => x.status == "Complete") It will produce new array containing only the objects where status = Complete. The expression will work only if the input data is array. I guess that, in your case the data is already split before the step where the expression is put (and that's the reason why it is not working). If your data is already split, then you can filter the records using Filter Snap with the following expression: $status == 'Completed' So only records with status = Completed will be sent further.