SpiroTaleski
Valued Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Filter in map after aggregate & group by
Colossal8333 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. Or maybe you can share the screenshots of the pipeline and the output of the snap before the expression is applied, so I will have a better understanding of the current issue.Re: Renaming multiple items in an array
AvaniAnand If you want to add another mapping rule, you can do that withnin the existing mapKeys function: map(x => x.mapKeys((value, key) => key.contains('Memo') ? "description" : (key.contains('unique_id') ? "custcol_xero_unique_key" : key))) Or, if you need to add conditions for more fields than also you can utilize the match operator.
