Row value count

KNIME Analytics Platform
1

Hi Friends for example I have in a column values in rows like this

 

 

1.            mike,john,peter

2.            mike

3.            john,peter

 

Is it possible to count them ? and to create a new column, with the value ?  for the first the value would be three and so on ? is it possible

 

 

thank you !

2

Sure,

Use the Cell Splitter node, choosing comma as delimiter and to output as a List.

Then use the Column Aggregator node, choose this new List Column in the Column tab, and in the Options tab choose Union Count.

 

Simon,

3

SImon thank you ! Works very well