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
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) ), {} )
Thanks a lot Siddharth, I've missed this detail...