i have a question on the group by node.
I compared two tables (columns), if they are the same or not.
No i want to count how much matches i have for each column. I try it with the group by but the node just counts every cell. How can i adjust this so that only the matches (all cells that are TRUE) are counted.
ID1 | ID2 | compare#1 | source1 | source2 | compare#2 | class1 | class2 | compare#3…
123 | 123 | TRUE | SAP-BW | SAP-BW | TRUE | 1 | 2 | FALSE
453 | 453 | TRUE | SAP-BW | SAP-BC | FALSE | 2 | 3 | FALSE
532 | 532 | TRUE | SAP-BW | SAP-BW | TRUE | 1 | 1 | TRUE
At the end i want to have something like that:
data1 | data2| total count | count matches | count mismatches
ID1 | ID2 | 3 | 3 | 0
source1 | source2 | 3 | 2 | 1
class1 | class2 | 3 | 1 | 2
This is like an overview over all columns