Geek asks and answers

Pentaho Spoon - output multiple files based on the contents of a field

I am trying to split the results of a pentaho conversion into several files based on the value of a specific field with no luck.

eg. A result set containing the following:

SURNAME, FIRST NAME, COUNTRY

Obama, Barack, USA

Cameron, David, UK

Blair, Tony, UK

The result will be the creation of 2 output files:

USA.txt - containing Obama and UK.txt - containing the other 2 lines

Any pointers would be greatly appreciated.

+3
source share
1 answer

You can create a field action as the name of the output file based on the Country field. A new constructed field was sent as the output file names in the "Output a text file" step.

See screenshot below:

enter image description here

http://pentaho.phi-integration.com/kettle/kettle-files.

, ...

+8

More articles:


All Articles