added
LIST_AGG() columns for Aggregate Activity Relationships
over 2 years ago by Brittany Davis
Users can now create a list of values from a collection of append activities using the LIST_AGG(...) function for aggregate relationships in dataset.
This can be helpful when you want to know a list of products a customer purchased within an order, but don't want to add additional rows to your dataset. Dataset also enables LIST_AGG(Distinct ...) so that users can compute a distinct list of features.
How to use it
- Add an activity with any AGGREGATE append relationship within a dataset
- Add a new column from that activity by selecting the (+) from the left side panel
- Use the dropdown to choose LIST_AGG(...) or LIST_AGG(Distinct ...) for the feature you want to aggregate
User feedback helps Narrator improve. ❤️
We'd love to hear what you think. Email us @ [email protected]