Counting with group by node

Hello,

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.

for example:

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

Thanks alot

hi @Mo_Gha
If columns compare#1,…, compare#n are of type boolean you can use Groupby node with no aggregation groups and an aggregation setting like this one

Hi @duristef,
thank you for your answer!
The problem is that the columns are of type string. I tried to convert them into boolean with the string manipulator but as i know you can only change one type with one node and not all columns at once ?
Do you have an idea how i can change all of the columns at once?

Or are there any other possibilities to count them?

You can use the String Manipulation Multi column configured like this

4 Likes

that worked perfectly, thank you very much!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.