How to split one input into K output tables looking into column?

I have one input table that have some columns. How can I split this table by one column.

For example: I have table with columns:

(s)Name (s)Surname {...}Job
Thomas Blue [teacher]
Damian Red [nurse]
Will House [teacher]
Tom Cat [cat]
Wendy Forest [teacher]

As output i want have to 3 (because there are 3 jobs: teacher, nurse, cat) tables that contains records:

(s)Name (s)Surname {...}Job
Thomas Blue [teacher]
Will House [teacher]
Wendy Forest [teacher]
(s)Name (s)Surname {...}Job
Damian Red [nurse]
(s)Name (s)Surname {...}Job
Tom Cat [cat]

 

Hi,

you could use the Group Loop Start node to process the rows for each job separate. Just select the Job column as group column in the Group Loop Start node and perform the analysis of each job within the loop body before adding a Loop End node that collects the results of each loop iteration. You can find some explanations on how to use loops at this blog entry.

Bye,

Tobias

some trick... 

not sure if it helps..