Pentaho Spoon - Output to multiple files based on field content
11,992
You can construct a field act as output filename based on Country field. Sent the new constructed field as output filenames in "Text File Output" step.
See the flow screenshot below :
You can also download the solution file from here http://pentaho.phi-integration.com/kettle/kettle-files.
Hope this helps...
Dino
Related videos on Youtube
15 : 52
How to import data from multiple CSV files in Pentaho | Pentaho PDI
05 : 33
create file based on run time Data
04 : 42
Extract - Pentaho Data Integration (ERROR)
08 : 22
Pentaho ETL Mengubah Microsoft Excel Input To XML Output dengan Select Value & Replace in String
03 : 03
PENTAHO DATA INTEGRATION - Reading multiple text files (RegEx)
05 : 07
Merge mulitple csv files into single file in Pentaho
08 : 26
Pentaho 8 - Tutorial 3 - Getting data from a database by providing parameters
03 : 25
S3 file output in Pentaho
04 : 01
Copy Files In Pentaho
04 : 48
Adding one field in each file using Pentaho
20 : 00
CSV Input | Table Output | Pentaho Data Integration | Kettle | Spoon | Transformation |Read CSV File
04 : 03
Pentaho Data Integration - Stream lookup basics - Tutorial - 9
Author by
t_barbz
Updated on June 04, 2022Comments
-
t_barbz almost 2 years
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.