am new to forum and pentaho ...
I have used SSIS previously, in SSIS there is a step called Conditional Split which lets me include many conditions in the flow and divide the output according to the conditions.
For example lets say there is a column with english and spanish names in it.
now if I add condition like name == "english" then i will get only english names. I can add as many conditions I want.
In pentaho I observed that there is a step called Filter Rows. Although it is similar in a way but I can get only 2 outputs. So lets say I want to divide a column in 5 different cases I cant do it. So is there a step to do it in Pentaho or do I have to use 5 different steps for 5 cases??