Group by variable and finding total numbers
Hi, I am beginner with KNIME,
I am trying to group data for column1 with other column values and need to arrive at number of grouped values. For example
Hotels C1 and Cancellation C2
Citadel, 0
Sherton, 1
Citadel, 1
Sherton, 0
Citadel, 0
Sherton, 0
Group by should result in
Citadel, 0, 2No
Sherton, 0, 2 No
Citadel, 1, 1No
Sheton, 1, 1No
How to achieve this in KNIME
Thanks
ChandraNR