Hi,
I have a CDT that contains many lines. How would you construct a new CDT (new local variable) with merged lines (with average calculations) depending of a field values ? (like the picture below)
Naively, I would use a foreach and create some lists, but I'm sure Appian provides some great functions to make this stuff easier :-)
(the question is not SQL-query oriented, I'm looking the best way to do it with SAIL from an existing cdt)
Regards
Discussion posts and replies are publicly visible