Data360 Analyze

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?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

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"])

Thanks Gerry. I'm not talking about groupSum but groupString. This macro would take all the string values in a field for the group being aggregated and concatenate them into a single string field for the output record.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

I'm sorry, I completely misread it! Here's how you do you group string with a pipe delimiter:

out1.GroupStringField = group.joinStrings(in1.FieldName,False,'|','')

Thanks Gerry. And that would also be done in the ConfigureFields node of an Aggregate node?

Is there somewhere some more in-depth documentation that I'm missing? Where would one find this stuff by the old "RTFM" method?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Yes, in the ConfigureFields, exact same as group sum. This link has more information on it.