Hi all,

I am using Kettle occasionally but for typical tasks.This time this i come up with a doubt.

My requirement is:

I have a big input .csv file which has 15 columns and each column contains about 40 lacs of data.Now I'd like to count the number of repeated values in a column.

e.g. under the column name 'Sex' ,I want to know how many 'M' and 'F' s are there.

can U please help by suggesting the better way to solve this .

Thanks in advance.