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

georgeu over 9 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 sikhivahans over 9 years ago

I should say that the view or stored procedure should do the job as desired by you (for instance, group by and group concat operations) and finally you would be left with querying these objects in Appian to obtain the data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

I should say that the view or stored procedure should do the job as desired by you (for instance, group by and group concat operations) and finally you would be left with querying these objects in Appian to obtain the data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data