I have been attempting splitting the results of a pentaho transform into multiple files based on the value of a specific field without any luck.
E.g. a result set containing the following:
SURNAME, FIRSTNAME, COUNTRY
Obama, Barack, USA
Cameron, David, UK
Blair, Tony, UK
Would result in 2 output files being created:
USA.txt - containing Obama's details and UK.txt - containing the other 2 rows
Any pointers would be greatly appreciated.