How to merge lines and calculate average data on a CDT

Question

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

Siddharth · Answer

This is because you are not filtering out the data properly. The index operation in line 22 should be used on local!subsetData and not local!vehicles. 
 index(
 local!subsetData,
 wherecontains(
 tointeger(local!parent1),
 tointeger(local!subsetData.subtypeid)
 ),
 {}
)

How to merge lines and calculate average data on a CDT

Top Replies