How to replicate groupString macro in the new python-based Transform or Aggregate nodes
Hello,
I used LAE for years before switching to Data360 Analyze. Just about the only thing I miss are is the groupString macro from the old Agg Ex node.
I feel like this should be possible using the Process Records window in the Advanced tab of the Aggregate node but I'm having no luck finding documentation on how to do this. Can anyone help?
-
You can't use the group sum feature in ProcessRecords, it belongs in ConfigureFields. In an Aggregate node and select Sum and your field from the drop down menu in Operations, then change the view from Grid to Advanced you'll see something like this in ConfigureFields:
outputs[0]["Total"] = group.sum(fields["Price"])
-
Yes, in the ConfigureFields, exact same as group sum. This link has more information on it.
Please sign in to leave a comment.
Comments
5 comments