Hello,
i need help to obtain the below results. From:
num has_breached sla_name
100 false P1 RES M
100 false P1 CON M
200 true P2 RES M
200 false P2 CON M
500 true P2 CON M
500 true P2 CON M
300 true P5 RES M
300 false P5 CON M
999 true P1 RES M
999 false P3 RES M
999 false P3 CON M
All pairs *RES M values in sla_name translated (aggregated) together in sla_response column and
all paris *CON M values in sla_name translated (aggregated) together in sla_contract column
To:
num sla_response sla_contract
100 false false
200 true false
500 true true
300 true false
Note that object with num 999 has 3 rows, in case of objects with 3 or more rows, is it possible filter out the related rows?
Thanks,
L
... View more