#aggregation I would like to aggregate the information I am bringing back in a d

georgeu over 8 years ago

#aggregation I would like to aggregate the information I am bringing back in a datasubset by one of the fields. Normally I would use a!queryAggregation in my query, but I do not want the min, max, sum, average, or count. I would like to concatenate the information based on one of the fields, preferably with a certain set of characters in between each value. Does anyone know how to do that?

Discussion posts and replies are publicly visible

Parents

0 Andre Dessens
Appian Employee
over 8 years ago

You can also try to pre-concatenate the data when you add it in the DB. That way you avoid the overhead of having to concatenate the data in real-time. This should be feasible if you will only need the data in concatenated form.

If you do need both the concatenated version of the data as well as separated, you can still follow this approach by creating a separate table dedicated to store the concatenated data and use that in your view or queryEntity as applicable.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Andre Dessens
Appian Employee
over 8 years ago

You can also try to pre-concatenate the data when you add it in the DB. That way you avoid the overhead of having to concatenate the data in real-time. This should be feasible if you will only need the data in concatenated form.

If you do need both the concatenated version of the data as well as separated, you can still follow this approach by creating a separate table dedicated to store the concatenated data and use that in your view or queryEntity as applicable.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data