Dear Experts,
I have the data structured as below in 2 different tables
Table1 | |
Sales Order | Cluster |
SO1 | C1 |
SO2 | C2 |
SO3 | C1 |
Table2 | |
Sales Order | materials |
SO1 | |
| A |
| B |
| C |
| |
SO2 | |
| A |
| B |
| C |
| D |
| M |
| |
SO3 | |
| A |
| D |
| E |
| F |
| G |
After loading the data, I’m getting the output as below
Cluster | Materials |
C1 | A |
| B |
| C |
| D |
| E |
| F |
| G |
C2 | A |
| B |
| C |
| D |
But I’m looking for output to be something like this.
Cluster | Materials |
Just C1 | E |
| F |
| G |
Just C2 | M |
C1&C2 | A |
| B |
| C |
| D |
Cluster | Count of Materials |
Just C1 | 3 |
Just C2 | 1 |
C1&C2 | 4 |
Can someone please help me here.
Thanks for your support.
-Raghava
