Mike, Some questions before I can give a suggestion:
> TEST_ID JFI_ID F_NAME N1_NAME N2_NAME MODE CHARACTERIST > IC PROPERTY > 1 1 FLOW_1 NODE_A NODE_B MODE_1 HIGH FLOW > 10 litres / > sec > 1 1 FLOW_1 NODE_A NODE_B MODE_1 HIGH FLOW > 50 gals / > hour > 1 1 FLOW_1 NODE_A NODE_B MODE_1 LOW LOSS Pump current < > 30 > 2 2 FLOW_2 NODE_C NODE_D MODE_1 LOW FLOW < 5 litres / sec > 44 3 FLOW_1 NODE_C NODE_D MODE_2 LOW FLOW < 5 litres / > sec > Q1. How can I group and LIST() to produce a single row for the first test case > (FLOW_1 from NODE_A to NODE_B with MODE_1). The result would look > something like this: > 1 1 FLOW_1 NODE_A NODE_B MODE_1 HIGH_FLOW, LOW_LOSS > > 10 litres / sec, > 50 gals / hour, Pump current < 30 Q: Did you mean to exclude the 2nd "HIGH_FLOW" characteristic value from the summary? Q: Do you require the relationship/relative position between the "characteristic" and "property" values be maintained in the summary result? Sean