Hello,
I am looking for information about how to count occurrences on several columns.
My table is something like that:
| ProdA | ProdB | ProdC | ProdD | ProdE |
| 4 | 5 | 6 | 7 | 8 |
| 1 | 2 | 3 | 4 | 5 |
| 6 | 7 | 8 | 9 | 10 |
| 3 | 4 | 5 | 6 | 7 |
And i need an output like this :
| IDproduct | Nb |
| 1 | 1 |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |
| 5 | 3 |
| 6 | 3 |
| 7 | 3 |
| 8 | 2 |
| 9 | 1 |
| 10 | 1 |
I tried GroupBy node, Value counter node but i really don't know how to do this.
Thanks in advance,
Alexis