Dear Team,
I'm struggling to get all possible combinations of each value. I need to create a list of all possible combinations of values for each. Below is an example of the input and the expected output. Any suggestions on how I could solve this?
Input
C1 | C2 | C3 | C4 | C5 | C6 | C7 |
Mismatch | OK | OK | OK | OK | OK | OK |
Output
C1 | C2 | C3 | C4 | C5 | C6 | C7 |
OK | OK | OK | OK | OK | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch |
Mismatch | OK | OK | OK | OK | OK | OK |
Mismatch | Mismatch | OK | OK | OK | OK | OK |
Mismatch | Mismatch | Mismatch | OK | OK | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | OK | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK |
Mismatch | Mismatch | OK | OK | OK | OK | OK |
Mismatch | Mismatch | Mismatch | OK | OK | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | OK | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK | OK |
Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK |
Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK |
And go on, till all the possibilities are completed.
Solved! Go to Solution.
Thanks