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