Forum Discussion
Solved
Matrix with multiple culomns by multiple colomns
Hello, I think i'm trying to do something simple but I cannot find how. I have data looking like this: ID Good1 Good2 Good3 Bad1 Bad2 Bad3 1 x x x 2 x x ...
trying to do something simpleahaha. Good one. None of this is simple.
Here's a version that works but at a high cost - an atrocious data model
see attached.
Here is a more accurate version that also considers the non-matches.
